-
Why is my Smartsheet Automation forms not sending out emails?
Hi there Hoping someone can help me with my Automation forms I am trying to send out to my team for a weekly report I need them to fill out. This is what i have set up below and for some reason whatever I try the notification or emails just aren't sending out to my team and im not sure how to make this work. Please advise.…
-
Row automation - add to top of sheet
Add an option when using automation to move/copy a row to add the row to the top of the sheet.
-
Copy Row automation brings original sheet 'Created date' instead of showing date it was moved
Please help, I have a helper sheet that I am using to capture time stamps of when a row goes to different statuses (ex: capture time stamp when request status changes from: In Review, Pending Response, and Completed). To do that I set up a copy row automation that triggers when those statuses change. Then it copies the row…
-
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.…
-
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…