Help

Making a field dependent on another

Topic Labels: Base design
Solved
Jump to Solution
2453 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Sam_Greenberg
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi!
I am new to Airtable. I am currently setting up an Airtable spreadsheet and one field (column) has a date. Is there any way possible to make the column next to it show what date it will be 2 weeks later?

Regards,
Sam

1 Solution

Accepted Solutions
andywingrave
10 - Mercury
10 - Mercury

This is the field/column to use:
CleanShot 2020-05-08 at 14.59.17
Replace the word “date” with your field

See Solution in Thread

3 Replies 3

Hey! Yep - You can use a formula:

DATEADD(Date, 14, 'days')

How would I tell the system which column to add it from @andywingrave? It says that it is not valid.

andywingrave
10 - Mercury
10 - Mercury

This is the field/column to use:
CleanShot 2020-05-08 at 14.59.17
Replace the word “date” with your field