-
Automated Workflow - Mutiple sheets to one sheet
I have an automated workflow set up on multiple sheets to move rows to one sheet when an action is triggered. I've noticed it only works on one sheet. Does that automation only work on one sheet or is there a way to have multiple sheets move rows to one sheet? Thanks!
-
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…
-
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…
-
Send as Attachment - Current User
I would like the ability to use the report feature "Send as Attachment" with a "Current User" filtered report, where the person gets a pdf or excel version of the report filtered by who the report is being sent to. My situation: I manage a list of colleagues in a sheet and need to send a report to their respective leaders.…
-
Merged: Create your own Automation templates
This discussion has been merged.
-
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…