Skip to main content

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

Hi, @Ryan_Murphy1 

Is this correct?

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

 

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!

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

Reply


Terms & Conditions