Hello! I'm trying to send an update request to be alerted during the following time periods: 30 days after the initial row was added 60 days after the initial row was added 90 days after the initial row was added I have an "entry date" field to build off of to serve as the date the row was added. Is there a way to do this through the "update request" workflow feature? Is this what the condition of "entry date" is "not in the last 30 days" would suffice? Or is this something that a formula has to be created for? If so, how would one do that? Any help would be great! Thanks, Lauren

"entry date" is "not in the last 30 days" would trigger at 31, 32, 33, 34, etc. days as they all meet that criteria. The way I would suggest setting it up is adding 3 columns. One for 30 days, one for 60 days, and one for 90 days. If you set them all to Date type columns, you can use a formula of =DATEONLY([Created Date]@row) + ## Then just enter the appropriate number of days. From there you can set your Update Requests to trigger on those date columns so that it will only send one per row at each of those specified dates.

Smartsheet will autofill as new rows are added as long as there are two rows of the same hierarchy above or below it that already have the formula in it.

Sending An Update Request after 30 Days

Answers

Paul Newcome ✭✭✭✭✭✭

09/03/20

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Trending in Formulas and Functions

How to update certain cells in column based on one cell's input and other column's same ID #?
I have a very simple test script testing tracker located here: I want to be able to do one of the following: 1. Update the Status column for all testers with the same test ID to "Duplicate" once one person tests and puts "FAIL" in the PASS/FAIL column. 2. Do not copy defects to defect tracker sheet if one of the rows with…
Duplicate Formula
I have a Smartsheet which is fed from a form an Intake team is using to gather prospect information and we are having issues with duplicate entries. The sheet/form has a field for prospect first name and another for prospect last name which we would like to check for duplicate entries of. I created a column combining both…
Countifs date is this month and a day of the month
Hello all, I am using the formula to count from a list of dates in another sheet to find all entries that are from this month. =COUNTIFS({Date}, IFERROR(MONTH(@cell ), 0) = MONTH(TODAY()), {Bay}, Bay@row) I would like it to also register if it is the 1st of the month (for the column named 1st) and the 2nd of the month (for…

Sending An Update Request after 30 Days

Answers

Help Article Resources

Categories