-
Changing a dates color once it is within 2 weeks
I would like to automate a change to my date column once we are within a month, 1 week, and once the date has passed. I would like these to have corresponding colors depending on how far out the date is. Wondering what options I have to do this? For example, I would like end dates colors to either be green if it is beyond…
-
Recording Changes made in SmartSheets - Row and Column Modifications
Hi Everyone! I was wondering if anyone knows any good ways to record a changed value in Smartsheet's, for the purpose of reporting it in Power BI? We are keen to understand and show the client what changes are being made to the sheet, by who, and what data is being changed (e.g. the status category to changed from…
-
Allow automation to populate cells with formulas.
For some reason the devs have blocked using =formula() and they populate cells with '=formula() when you try to use the features in conjunction. This makes your formulas inert and is quite frustrating. This seems like such a easy way to increase efficiency in the program and should be implemented immediately. Thanks for…
-
Automation Not working "Alerting two days prior of date"
Background We have a form where users select a date from a dropdown. However, this dropdown isn't recognized as a date field for automation purposes, so I've created a helper column for dates. PA Dates is the dates drop-down column in form (Dropdown Column) PA Dates Helper is the helper date column (Date Column) Goal To…
-
Simple Automated workflow not working
Hello, I have seen some other posts on this issue, and the fixes listed didn't help me. I have tried to duplicate the workflow and delete the old one. I also want this to work in real time and I do not want to automate this to a certain time of day. The trigger is as simple as it gets. When any field within any row is…
-
Export option for Control Center Auto Provision Log
We'd love it if we can have export of this Log from Control Center > Automation I was troubleshooting what went wrong on the Auto-provisioning of some of our projects and I found bunch of these error messages along with provisioning. When I look further there were more than 2 than what I was originally looking into… it'll…
-
Automation to record a date isn't working
I'm hoping someone can help. I've used Smartsheet for years (at another company) and have never ran across this. I'm trying to record a date when the status changes to "1st Review". I have even gone so far as to create test columns where there is nothing, no formulas, conditional formatting, etc. attached, toggled Date…
-
Automation Errors - Not going to Correct Approver
Hi everyone, I'm encountering a problem with my workflow automation for system change requests. I have three separate workflows, each corresponding to a different set of manager and director approvals. Expected Behavior: Country X: Manager 1 -> Director 1 Country Y: Manager 2 -> Director 2 Country Z: Manager 3 -> Director…
-
Automation works when triggering manually but not if I leave it (although it says it runs)
Hi all, i have this set up to run every day at a certain time. When i check it after the time it's set I can see the automation has been triggered but it does not do what is intended which is send out and email and then change a cell value to checked. One of the conditions for this is after 3 days. However, if i run this…
-
Is there a way to copy a folder or workspace and have the automations direct to the new workspace?
I am trying to create a workspace that is a template for our projects. This workspace has 15 sheets with 28 automations each that direct content to 28 separate sheets based on a selected topic. When I save as new the workspace for a new project, every single one of those automations has to be updated because they all still…