I am looking for a way to set up a workflow so that once a box is checked, an automated email will get sent out to a person a few days later.
The first step is setting up a Record A Date automation to populate the date in a date type column when the box is checked. Then you would use another date type column with a formula to output the desired automation send date based on the Record a Date column. Finally you would set up your email send automation to run on this second date column.
CERTIFIED SMARTSHEET PLATINUM PARTNER
Efficiency Live: The Ultimate PM Toolkit Workshop
@Paul Newcome how would I write the formula if I need to run the automation when column A is either "a, b, or c"?
Right now I have something like this =IF(About@row = "A", [Auto Date]@row + 30). This works for that choice, but I need it to work if the "about" column is also B or C.
You would use an IF/OR.
=IF(OR(About@row = "A", About@orw = "B", About@row = "C"), ...............)
Hello, I am working on a training log for our company. I am trying to get the status color to turn green if training is completed, yellow if it is due in the future, and red if it is incomplete. I keep getting an incorrect argument. I had it working correctly when I was just doing red and green, but I really need that go…
Hi, I have a sheet that collects data from several forms. I have an automation that kicks off every Thursday at 5:00 AM to move all the data in the sheet to an archive sheet, I have another automation that is supposed to kick off at 8:00 on Thursday to check if the column is blank, then alert someone via an email to enter…
Hi. Does saving a sheet after hiding columns delete the hidden columns or will they still be there?
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2024. All Rights Reserved Smartsheet Inc.