Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Workday Difference formula: Can I create this to fill in today's date if another column date is empty?

Topic Labels: Formulas
470 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi!

I’m looking to see if I can modify a WORKDAY_DIFF formula I have:
WORKDAY_DIFF({Date JIRA submitted},TODAY())

Ultimately, I’d like the formula to look at if the “Due Date” column is filled in, and if it is, then return the days between “Date JIRA submitted” and “Due Date”. If “Due Date” is empty, then return the days to TODAY(). Guessing this is an IF statement?

Is this possible?

Thanks!
Jeannie

2 Replies 2

Hi @Jeannie_Ruesch_BDC - to avoid fields showing “#ERROR” you first want to check if the JIRA date exists, then if it does, check if the Due Date exists, so this should work for you:

IF(
  {Date JIRA submitted},
  IF(
    {Due Date},
    WORKDAY_DIFF({Date JIRA submitted},{Due Date}), 
    WORKDAY_DIFF({Date JIRA submitted},TODAY())
  )
)

THANK YOU! That worked - exactly what I needed. And yes - I was getting error on my other formula, so appreciate that, as well.

The Airtable community is amazing. :slightly_smiling_face: