Help

Count # of days between status change and due date

Topic Labels: Formulas
542 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Ryan_Murphy1
4 - Data Explorer
4 - Data Explorer

I use airtable for marketing project management of creative requests. I would like to count the timelines that my team is given. I want to count the number of days from the moment a record status is changed to "Ready for design" to said record's due date. I have a DATETIMEDIFF from date created to date due, but that is no longer working for our team. TIA

3 Replies 3
Sho
11 - Venus
11 - Venus

Hi, @Ryan_Murphy1 

Is this correct?

IF({Status}="Ready for design",DATETIME_DIFF({End Date},NOW(),"days")+1)

 

Hmm. I got that to work (as in no errors) but it returned a blank cell!

{Status}, "Ready for design" and {End Date} need to be modified to match the fields in your table to work