-
I used automation and move a row and the row disappeared off of my sheet but did not appear on the t
I do not see an error log, additional columns headers were added to the the target sheet but no data ever appeared. how can i find out if there was an error or even see my data? I changed it to a copy so I would not "lose" any more data until I got it figured out.
-
90 Day follow-up alert
Hello All, I am trying to create an automation that notifies me 90 days after the Actual Closed Date so I can do a follow-up. Is there a way to do this or do I need to do a workaround formula that calculates 90 days after the date in that field and then have the alert be once that date is reached to send me something?
-
Sheet Owner on Automation Emails
When a notification is sent, the automation email is sent like it is coming from the Sheet Owner rather than the user that actually updated the row and triggered the notification. This is confusing because often times our customers don't know who the sheet owner is or they don't interact with that person. Can this be…
-
automation with clock timer
Hello , Date column is not enough for automation updates/approvals and reminders , we need to send it conditioned on time formula ( clock ) . For example like to insert task time and and to create automated reminder / update or approval request that with condition based on time , like if the time is 1,2, 3 hours is less…
-
Workflow automation to alert people upon cell change from 'unchecked' to 'checked'
Hi, An automation workflow is created. Specific people are assigned to be alerted upon cell change for specific row from 'unchecked' to 'checked'. Workflow to run when triggered. After trying multiple times, the workflow seems not to be active and working. See image below. Please advice, thank you.
-
Moving Parent and Child rows to other Sheets
Hi, Looking for some help moving rows to another sheet. We use one specific sheet to track ALL deliveries that come into our warehouse. A clerk in the warehouse makes a Form Entry for every group of items on the same packing slip, and attaches a photo of the packing slip for reference. Remotely, another clerk will read the…
-
Automated interactive Subject line and email / Update request
I love the the automated update/approval emails feature and i wonder if its possible the subject line can add more information with a code trigger from one of cells and not to have the exact same subject all time Also the sent to email to be triggered from contact email and not same email setup Thank you
-
Notification delay
I have a series of workflows set up for a form/sheet I am using. The process goes like this: 1. Someone submits form 2. Triggers approval email to be sent 3. If approved, this triggers an email to the requestor that their request has been approved. 4. This also triggers a different email notification to another email…
-
Automated Dashboard Metric Updates
Hello! I have a dashboard for one of my projects where I use a metric widget to share updates on each objective. I have an underlying sheet that sends out update requests every two weeks to the leaders of each objective. I have an automation within the sheet that archives old updates to an Archive sheet. I want the latest…
-
Convert form response in to standalone project?
Hi, I created a Smartsheet form to intake requests for support from my team. I'm not aware of an easy way to then create a project based off of the form response without having the Control Center add-on. Ideally I would like to set up a system where I can view the incoming requests then approve/reject/send back for more…
