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…
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
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…
This discussion has been merged.
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…
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…
When creating an automation workflow from scratch, where we request an update, is there any way we can make the fields that they have to fill out required? What we noticed when we did this was that multiple people were not completing all the information we needed them to, so when we would see what was updated in the…
for example if the status says in progress i want the %complete column to automatically say 50% can anyone help me?
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…
Can anyone tell me how to find the source sheet of an automation email? An email was sent to someone in error which they forwarded to me but there is not enough information on the notification to identify which sheet is the source of the automation? There is an ID at the bottom of the notification, am I able to use that to…