In an approval workflow when someone is notified on the Approved/Declined status, we have built a "message only" alert back to the user who submitted the request. The user will never be shared to the …
I have automation set up to work off a checkbox column. When I check the box, I want four separate emails to go out to four separate groups. Each group's email provides a distinct link specific to the…
I have been trying to create several automations that simply update a field based on the data in another field. Example is when Status = Complete, update % Complete to 100%. OR When status = Complete …
In my organization, we have ID numbers for tasks. They go something like this: Top Level: AB Second Level: ABcde Third Level: ABcde1 Fourth Level ABcde1.1 Where ABcde1.1 is the child of ABcde1 which i…
Hi everyone, I would need a formula where it picks the nearest date in the past related to today's date in another sheet. To give more context, the other sheet always shows Mondays as dates. I tried I…
Hi everyone, I am trying to automate symbols. The logic should be if the specific cell is below 90% then mark it as a red symbol, if it is greater than 90% mark it as yellow if it is greater or equal …
I have the following columns that are linked to another smartsheet: Citrix Status - Network Status - PC Status - Phone Status - Completion Date When all columns have the "Complete" status, the Complet…
We use a smartsheet to track the progress of investigations on my site. The investigation ID, description, etc. are stored on an Oracle SQL DB and I'd like to autopopulate the smartsheet with the rele…
I need a formula that calculates 3weeks date, 2 weeks date, 1 week date and 24 hours date from a due for each column where the due date is another sheet. Let's say column Citrix status in another shee…
Hello, I created a workflow to move rows once a column status is changed to "complete" within any row. But the workflow didn't trigger, even when I manually changed the status to something else and ba…
