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

If Statement Help
I could really use some help! I am trying to write an if statement. Based on: Due date being < = -68 New entry is "starred" Entry 1 = "yes". I want it to be complete if it meets the conditions listed above and incomplete if it doesn't meet those conditions. This is what I tried: =IF([New Entry]@row = 1, [Entry 1]@row,…
can i use sumif formula with my criteria referencing a cell in my sheet?
Hi Im trying to create a formula that pulls a sum from different sheet when the criteria matches a cell in my current sheet- is this possible? i get invalid operation when i try…
Countifs, with a cross reference and an or
Hi there, I'm trying to count how many red risks I have in my RAAIDD log that are not closed or complete. I've written the below, but I can't get it to work. Any advice would be gratefully received, please. =COUNTIFS({NAME RAAIDD Range 1}, "Risk", {NAME RAAIDD Range 3}, ">=8", {NAME RAAIDD Status}, OR(@cell = "Open", @cell…