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.

How to set reminder when activity is not marked complete and current date is greater than finish dat

Girish Gupta

Girish Gupta ✭

03/16/17 edited 12/09/19 in Archived 2017 Posts

How to set reminder when activity is not marked complete and current date is greater than finish date for all the tasks in the sheet.

0 ·

Comments

J. Craig Williams ✭✭✭✭✭✭

03/16/17

Girish,

You will need to create a column with a formula.
Something like this, expanded to include the date comparison

https://community.smartsheet.com/discussion/sending-reminders-assigned-techs

Craig

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Compare two columns and return a yes or no
I have two columns on one sheet that I want to compare. If the value in Column A matches any value in Column B, I want a yes to be returned in Column C. I've played with the formula for over an hour and can't get it right. =IF(CONTAINS([RDS Serial #]@row, [Serial Number]:[Serial Number]), "YES", "NO")
Help with IF formula - 3 options to return
Hello Smartsheet Community, I'm struggling with something that I guess should be a very simple formula. I need to assign one of 3 values to the row based on the following rules: If Cutoff Date > Event Date, return "Pre-" If Cutoff Date < Event Date AND Weeks Post Cutoff Date </=8, return "Post1" If Cutoff Date < Event Date…
filter
Hi, I created a filter in one of my smartsheet. And I add some people to my smartsheet. Is there a way that they can't see my side if i'm the admin. user