SEND REMINDER ONLY IF TASK IS NOT COMPLETE

jtudisco17451

How do I setup a reminder to only email if the "Complete" box is not checked off? It seams that there is not a way to add a condition in the reminder setup.

Shaine Greenwood

Hello,

There currently isn't a way to set a conditional reminder in Smartsheet. When you have a moment, please submit a product enhancement request using the form under Quick links on the right of the community site.

As a potential workaround, you might consider using an additional date column in your sheet and creating an IF statement that will populate the date from your other column if the "complete" box is unchecked. You could then base a reminder off of this date column instead. An example of this formula is below:

=IF([Complete]1 = 0, [End Date]1)

More in IF statements can be found in our help center: https://help.smartsheet.com/function/if