Automation - Trigger when cell is blank and date in another cell is within 5 days. Is it possible

Sanjay Josee

Paul Newcome

You would set your trigger to be the date is within the next n days and the condition would be where the other column "is blank".

Sanjay Josee

Thanks Paul

I am not sure how to make your logic work in workflow side for "within the next n days". I looked around and was not able to find that option.

Am I creating this in one of the col in the sheet?

Paul Newcome

My apologies. I was thinking of something different.

Add a checkbox column (that you can hide after setting up) and enter

=IF(AND([Column name]@row = "", [Date Column]@row <= TODAY(5)), 1)

This will check the box for each row that meets the criteria. You can then set your automation up to either run when the box is checked or run regularly so that it sends all rows that are still checked even if it was checked on a different date.

bhanville

@Paul Newcome - I need to use this functionality in my Smartsheet. I added a checkbox column and entered the following using your formula above:

=IF(AND([Contract End Date within 45 days]@row = "" , [Contract End Date]@row, <= TODAY(45)), 1)

I'm getting a circular reference error. The checkbox column name is "Contract End Date within 45 days" and "Contract End Date" is my date cell.

What am I doing wrong? Thank you!