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)
+2Hi, @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
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.