Hello, is there a way to set formula with a type of date that takes the date and uses the age column to take the age value? So if the date is set to April 5th and the age is 3 then the value outputted should be April 8th.
Idk what “age” means for you, but by default you can add a number of days to any date:
If [Date]=2021/12/31
[Date]+3=2022/01/03
2 Likes
age is a column in the app sheet, it’s something the user enters in the form, I want to take that value and add it to the date.
Pretty much what @SkrOYC said then, but instead of adding 3 to a column called date, you would add [age] to the current date:
today() + [age]
1 Like
The thing that I don’t understand is why would you add [age] to a date.
What does [age] represents?
Maybe you want to add whole years?
1 Like
I guessed age referred to some sort of shelf life, but very difficult to tell from the information we were given.
2 Likes