-
Automations only works after saving and refreshing
I've created a very simple automation. When my "Complete" column is checked, I want the "Status" column to update to complete. This automation only seems to work after I manually save the file and then refresh the browser. Frankly, that's a really bad user experience. The fields should update instantaneously, and saving…
-
Help need in Automation workflow.
Hi All, Need help in fixing Automation workflow which works only if I manually trigger. Basically, I'm trying to have Manager approve costing again if it's more than the allocated amount. I've setup 2 helper columns with the following formulas: =IF([Co-Op Allocation]@row >= [Co-Op Actual]@row, "0", "1") =IF([Markdown…
-
Removing duplicate rows in a sheet
Would love to see a feature to remove duplicate rows in a sheet. I have an automated rule setup to move rows into a sheet every day and some of the rows are duplicates. I would like to automate the process of removing those duplicate rows.
-
Create your own Automation templates
Hello, It would be so helpful if I could create a automation template that I could use across all my sheets. Right now i have to re-create the automation for each of my sheets. I wish i could just copy my automation from my other sheet or create a saved personal template. Thank you, Peter Taylor
-
Why is sheet adding rows from dropdown list?
Hi, My sheet is adding in new rows based on my list of dropdown selections. I added in some suppliers in a column which we may use in the future but currently do not have rows in my sheet. However, the sheet is bringing them in as new rows with that supplier name even though I am not asking it to do anything. Do you know…
-
Looking for a consultant to help build intranet/dashboard & basic CRM.
Hello, I am looking for a Smartsheet expert who can help us build a custom dashboard for internal and external use. We are based in Los Angeles, but most of our team works remotely. So are you / or do you know an English speaking Smartsheet expert, who we can hire for support and who has time the coming month? Thank you,…
-
Why can't I access the workflow automations on a sheet that was shared to me?
The sheet owner already made me an admin yet I still couldn't open the workflow automations tab (I can access the forms, edit the columns, rows, cells, and etc.) I have good network connection and I already tried refreshing the tab several times. They even removed me then added me again multiple time but the same message…
-
Move child row under new parent row when a cell value is changed.
I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent row. Is this possible?
-
Copy Row to another sheet - automation
Hi. I have setup an automation that should copy a row from the master sheet to sheet 1 if the Owner Column says "Jess". However it is only copying the Owner column "jess" to sheet one - not the entire row. Can someone help me figure this out? (Essentially it is a master task sheet and I want everyone to have their own…
-
Workflow Subscription
Hello, I have someone who unsubscribed from the automation workflow notification and now needs to be added back. How can this be done? Thanks!
