Oct 13, 2020 11:32 AM
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
Oct 13, 2020 12:07 PM
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())
)
)
Oct 13, 2020 12:22 PM
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: