
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 12:28 PM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 28, 2023 05:35 PM
Hi, @Ryan_Murphy1
Is this correct?
IF({Status}="Ready for design",DATETIME_DIFF({End Date},NOW(),"days")+1)

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 29, 2023 07:43 AM
Hmm. I got that to work (as in no errors) but it returned a blank cell!

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎Jun 29, 2023 04:26 PM
{Status}, "Ready for design" and {End Date} need to be modified to match the fields in your table to work
