Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
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.
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
