-
Has my automation run?
Hi How can if see if certain owners on my sheet have received their automatic email? There must be a history somewhere Thank you
-
Merged: One Form - Multiple Row Entries
This discussion has been merged.
-
Notification with link to dynamic view or published sheet
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.
-
Move row automation not working (moving additional rows not part of automation)
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…
-
Need more than 150 Workflows on a form
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,…
-
Trigger a warning - either via automation or conditional formatting
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…
-
Creating Automation to Log Specific Field Changes from One Sheet to Another?
Hello, I have a large multi-year project tracker. We have a manual select Risk column, where users will select the field should they anticipate a risk for the deliverable in question. I want to create an automation where when "Risk" is selected an automation is created to copy the entire row to a new sheet where the risk…
-
Copy Row Automation - Eliminating Duplicates OR keeping latest Row entry/update
Hello fellow Smartsheeters, I am trying to capture entries from a project level RAID log and pushing them (based on specific criteria) to an Enterprise level RAID log. Specifically, any Risks or Issues that are created and updated need to be pushed to another sheet. I am familiar and frequently use the Copy Row Automation…
-
Automatic formula
Hello everyone, In some fields in my sheets I have formulas. Is there a way to automatically report these formulas when I add new rows? Thanks
-
Automatically assign project requestor to the workspace
As of now it is only possible to assign a group of users to the blueprint of whenever a new workspace gets created for a new project. My idea is that there would be a possibility to automatically include the requestor of the project to the workspace, instead of the whole group. Perhaps it could be as follow: User requests…
