-
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…
-
Merged: Copy and move selective columns
This discussion has been merged.
-
Basic Automation Workflow
Hi Community, I created a very simple automation where the trigger is when my % Complete row changes to 100% I want the Status cell value to change to complete. However it does not seem to be working. When I tried to run the workflow manually it changed all of my statuses to complete even if the % complete is less than…
-
Workflow to copy a cell and paste its value in another cell when the first changes.
Hello everybody I'd like create a workflow to copy the value of a cell date type when it changes to another cell in the same sheet. I can trigger the workflow when there's a change, however I can find a way to bring this value to the other column without using DataMesh or Formulas. In my case I want to avoid to use these…
-
Hello, i need some help how do i connect the %complete column to the status column
for example if the status says in progress i want the %complete column to automatically say 50% can anyone help me?
-
How do I make my Smartsheet columns update when I update the Form
I'm brand new to Smartsheet Forms and I'm on deadline. I accidentally created a Form tied to the wrong Sheet. After realizing my mistake, I duplicated the original sheet and fixed the new column headers (which had populated when I created the Form, of course!) and went back to the original incorrect Sheet ... I THINK it's…
