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

Grid View - Default Values
Hi Everyone, thanks as always for your help! I have a quick question on the best way to apply default values when adding a new row to a grid view. The idea is that if someone enters a new task name, then the priority and status column for the task would automatically update to "Medium" and "Not Started" respectively. Then…
Adding to a report
Hello! So - I am working on building dashboards for my company where we can track To Dos. goals, etc. I have made reports, added them to the dashboards, and connected the report widget back to the data source (data source being the report NOT the original sheet). My question is - is there a way for people to just add line…
Automation Trigger Help
In the Project Management Learning Path via Smartsheet University, I'm running into an issue where it will not allow me to run the 'Regular Task Update Request' weekly on Monday, Wednesday, and Friday as the instructions ask me to do. My only options are X days before, X weeks before, X days after, and X weeks after. There…