Welcome to the Smartsheet Forum Archives


The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

SEND REMINDER ONLY IF TASK IS NOT COMPLETE

09/30/17 Edited 12/09/19

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.

Comments

  • 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

     

This discussion has been closed.