I would like both automations to be triggered when team members check off a task in the Done Column: The task should be marked as complete in the status column when triggered The current date should be added to the Completion Date column when triggered Currently, these are set up to run in the sheet and I'm not sure why…
Hello Team, I am preparing a service request spreadsheet. Users will be entering the issues, and the service request number should automatically pop up. upon all of the values entered. In this case, the Green highlighted values will be entered through customers via Form. Upon all of the values entered by customer,…
Hi Community, I need your help on a (possibly) simple issue I am facing. I have a very basic report with a very basic workflow. When a specific criteria is met, the workflow sends an e-mail with all the row details, including a link to a customer. Let's say that column is "Account Link" The issues come with the automated…
Hi all, Hoping someone out there can help and hoping its just something simple i need to change. We use Smart sheets to monitor cases by age outstanding to help prioritise what needs looking at first. so i have a formula to grab data from a cell says A1 that has the TODAY function in. and then take that away from the last…
Hi How can if see if certain owners on my sheet have received their automatic email? There must be a history somewhere Thank you
This discussion has been merged.
There should be the option to notify and put the link to the dynamic view or published sheet instead of link to the sheet. This makes easier to manage the new request to access sheet.
Hoping for help with the simple "move row" automation. I am attempting to move rows from Master Sheet to Sheet A. I have selected extremely simple criteria (see images) What is happening instead is random rows are moving with the automation. My criteria to move is drop down menu option = DROPPED. But what is happening is…
I just hit the 150 Workflow limit on a sheet I'm making. This sheet connects to a form which, to be successful, depends on the Workflows. The set up is that users select from dropdowns on a form, which triggers a Workflow to add a new line to the sheet with text from dependent on what dropdown was selected. There are many,…
I have a master sheet that I'm using to track the progress of roughly 100 other sheets. I'm pulling in data from those individual sheets of the various status of accounts. What I'd like to do is have an automation so that if the numbers don't change after a week, an email goes out. Or at a bare minimum conditional…
