I seem to have a 'ghost' in my sheet where only half of my automated workflow seems to work on any given day. My sheet (called a playbook) has half of the rows with =Today() date formula, and the othe…
We're using Smartsheet to track project requests. I'm working to build "personas" to show the type of projects coming in based on the requestors job function. Is there a way I could use automation to …
Hello, If I start an automation in the past, will it trigger on a date in the future? I want alerts to go start this coming Friday 2/25, and every two weeks after that. I set my automation up like thi…
Hi, I am trying to prepare reports that show certain information (eg, here are all the things that have happened in the last week/month/are coming up etc). If I do it as an automation in smartsheet, I…
We have a column with expiration date that is put in manually by an employee with the rest of the data when received. Currently we have conditional formatting to highlight the products expiring within…
Hello Team. I am setting up a sheet that would help track and act on over 3K documents based on their end dates. The two column I would like to work together are "end dates" and "expiration status". T…
Hi, Does any one know if there is a way to auto up date a subtasks dates when you move the tasks between parent tasks? The scenario is we have a course booking tracker and the PARENT task is the cours…
Hi all, I have a list of people with emails in my smartsheet. Some of them left the company, how can I find out from smartsheet that their email not exist anymore and to mark them in the sheet? Thank …
I'm not the best at the complicated formulas and need some help. I have 3 columns in play here. Submission Type (single select), Submitted date (automation added), and Due date (Date Field). If the re…