Skip to main content
Solved

Making a field dependent on another

  • May 8, 2020
  • 3 replies
  • 80 views

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

Best answer by andywingrave

This is the field/column to use:

Replace the word “date” with your field

3 replies

Forum|alt.badge.img+19

Hey! Yep - You can use a formula:

DATEADD(Date, 14, 'days')

  • Author
  • New Participant
  • May 8, 2020

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.


Forum|alt.badge.img+19
  • Inspiring
  • Answer
  • May 8, 2020

This is the field/column to use:

Replace the word “date” with your field