-
Formula for Referencing Cell Above Current Cell?
I have created this Smartsheet, where my team can record orders raised each month. This would then link to a dashboard (which would have to update automatically each month) to show monthly statistics regarding the orders from that month. This is what It currently looks like. Each month is child of its year and the orders…
-
How to Send Timed Reminders Based on a Trigger?
Hi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation figured out for approval or declination. I'd like to send reminders if no one answers that approval, though. What I'd like to…
-
Using Automation/Workflow to copy multiple languages form responses into one sheet
Hi, I have two forms one in English and one in Spanish. They provide exactly the same responses, just in their respective language. The Spanish version still has the field headers in English while the labels are in Spanish. I have created an automation that filters for a particular school and creates a copy of the row on a…
-
Linking three regional sheets to reflect in one global master
I am creating three sheets to track projects through the Americas, APAC and EMEA regions all will have the same column headings and will be updated by regional teams. I'd like to create a consolidated Global view of the projects bringing all regions together in one sheer that updates automatically when a change is made to…
-
Remove name from Automated workflow I created
How do I remove my name from I automated workflow I created and add someone else name. See image attached?
-
Automated Workflow --Multiple conditions with And Function--
Hi, I am trying to create an automated workflow with two conditions and I want those two conditions to be met at the same time, however, I can't seem to switch from "Or" to "And". Notification Type is alert someone and Trigger mechanism is when rows are added or changed. Thank you in advance for the support
-
After "Save As' from a worksheet, why does the MS Teams alerts have to be reset every time?
For our software's deployments, we use a checklist. There is a template and it is 'save as' before kicking off the next deployment process. There are e-mail automations and MS Teams automations. The e-mail automations stay the same but the Teams automations have to be reconfigured to the Team and Channel each time. Is this…
-
Automated Move Rows won't move anything
I have an automation set to run whenever a "Status" row changed (or row is added) with a condition: "Where Status Contains 'Out of Service'". It's set to alert me, then move rows. It alerts me just fine, but won't move any rows. Using the row options to move the rows works with ease, and no error messages ever appear. My…
-
Workflow to Update Date to TODAY() until another cell = 100%
I have 2 cells in a column: Which displays a % from 1-100 Which should show a date Is it possible to use a workflow or other automation to daily (at 12:01am or any other time) update the date field to TODAY(), but to stop updating it once the % field = 100%? Thanks in advance!
-
How can I set a dynamic filter on a report to auto change to today's date?
I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even today's date? For example, a condition that will say Original Go-Live is greater than…