Alert recurrence that looks at a date field - possible?

Melisa Dannhauser

I appreciate you helping so much, Paul. Unfortunately this doesn't help, I tried that before. When my submission date is 5/1, I'm trying to send an alert every 3 days. So when I enter the formula, the date displayed in case of 5/1 submission should be 6/8 (counting in 3 day increments from 5/1 until today, not counting weekends). However, this formula displays 5/28.

Paul Newcome

That makes sense too. Try this one...

=IF(AND(Status@row <> "Approved", [Date Column]@row < TODAY()), WORKDAY([Date Column]@row, CEILING(NETWORKDAYS([Date Column]@row, TODAY()), 3)))

Melisa Dannhauser

You got it, this works. You are great, thanks so much for taking the time to do this!!

Paul Newcome

Happy to help. 👍️

Deepika Kuna

Hi Paul, I have a smartsheet in which I want to send out a reminder 90 days from the date identified in the "date of modification" column and then have that reoccuring from the last time the reminder was sent out to check in on the requestor. How would want accomplish this?