Help

The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.

Trying to update a date based on another date

Topic Labels: Formulas
Solved
Jump to Solution
606 4
cancel
Showing results for 
Search instead for 
Did you mean: 
hthom24
4 - Data Explorer
4 - Data Explorer

My workflow is based on priority levels, so I'm trying to create a "Due date" field based on the last time a record was updated. 

What am I doing wrong is there a better way to create this date? 

1 Solution

Accepted Solutions

Hello,

Your formula is fine, you just need to remove the last comma:

Pascal_Gallais_0-1722414848888.png

Regards,

Pascal

See Solution in Thread

4 Replies 4
hthom24
4 - Data Explorer
4 - Data Explorer

Screenshot 2024-07-30 at 2.48.34 PM..png
Here's my attempted formula

Sho
11 - Venus
11 - Venus

 

Hi @hthom24,

Maybe you could do it this way.

DATEADD({Recently Updated},RIGHT({Priority Level},1),'day')

Hello,

Your formula is fine, you just need to remove the last comma:

Pascal_Gallais_0-1722414848888.png

Regards,

Pascal

This worked! Thank you