Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Nested If Date function

1598 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Jennie_Patterso
4 - Data Explorer
4 - Data Explorer

I am making a template to keep track of when our fleet vehicles plates expire. I want to put a function that will warn me of any expired plates but also warn me of when plates are coming due (example…tell me when plates will expire 1 month from today).
Please help. I do not know how to write this formula.

1 Reply 1

@Jennie_Patterson Maybe something like this:

Alerts

IF(DATETIME_DIFF({Date due},TODAY(),‘d’)<0,“ :stop_sign: :stop_sign: :stop_sign: Expired!!”,IF(DATETIME_DIFF({Date due},TODAY(),‘d’)<30,“ :warning: :warning: :warning: Due within 30 days”,BLANK()))