Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

If statement for blank dates, else countdown days to due date

Topic Labels: Formulas
730 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Elizabeth_Stock
4 - Data Explorer
4 - Data Explorer

Heya,

Can someone help me with writing if statemtent for my blank ‘deadline dates’, if there is a no date, I want my ‘Time Left Helper’ to say ‘On Going’ deadline rather than error. ‘Days’ is my countdown field, so i think I need to say if deadline date is blank then “on going” else, countdown days.

Then I’m not sure how to transfer this part to the Time Left Helper?

Maybe best to leave it to appear as blank and if blank then the time left helper writes ‘ongoing’

i am not sure…

Days formula:

(WORKDAY_DIFF(NOW(),{Deadline Date})-1)

Time Helper formula:

IF(Status = "Complete", "✅", IF(Days = 0, "Due today ⏰", (ABS(Days) - (2*(Days < 0))) & IF(Days > 0, " days left ⏳", " days overdue 💥")))

Screen Shot 2022-04-27 at 12.17.18 (2)

thanks!

1 Reply 1

Hi @Elizabeth_Stocks and welcome to the community!

Replace :point_down:

with :point_down:

IF({Deadline Date}, WORKDAY_DIFF(NOW(),{Deadline Date})-1, "on going")

And :point_down:

with :point_down:

IF(Days=blank(), "on going", IF(Status = "Complete", "", IF(Days = 0, "Due today ", (ABS(Days) - (2*(Days < 0))) & IF(Days > 0, " days left ", " days overdue 💥"))))

I do think you will get some false data if you use WORKDAY_DIFF() in combo with “-1”. Putting a deadline on yesterday will result in a “-3” for example. Using DATETIME_DIFF() won’t give you this problem.