-
Copy row for all columns before "Yes" Column
I am working on a project, and there will be MANY times that there will be multiple requests. This column is a dropdown with 2 options, "Yes" or "No". If the response is "Yes" I would like the data from that row, all columns PRIOR to that column copied to the next row. If the dropdown selection is "No" nothing is done.…
-
Automatically linking different sheets to a master sheet?
Hi, I am trying to create a master sheet with information I need that pulls specific cell data from multiple different project sheets. I know I can use vlookup's and reference another sheet within them but I'm wondering if there is any way to create a template or workflow so that when a new project is added to the projects…
-
Anyway we can automate SmartSheet to remove / delete rows.
I have a dump sheet that needs to be clear every day. Move row does not work, its adds another step into a simple task.
-
Change Cell Value After 2 Weeks
Hello, After someone completes a task on my sheet it sends out an approval automation for the requestor to Approve or Deny the work that has been done before moving it to a completed sheet. Is it possible to make an automation that will change the Requestor Approval column status to Complete if the requestor does not do it…
-
Assign People Automation
I'm using an Assign people automation to fill in contacts for several roles based on criteria or check boxes entered on a form. Each condition path should add a name to a different cell. It's only adding the first one. If I edit any cell and save, it adds the next one and so on. Attached screenshot. What am I missing? Is…
-
Change Status Ball for Old Row Entry When New Entry of Same Name is Created
I have a sheet tracking facility access qualifications for contractors; I need to change the status ball for a previous entry when a new row is created of the same contractor. Basically, when "Ron Cook" has a new row entry, change the status ball on the previous "Ron Cook entry to trigger automation to move the old row to…
-
Status Auto Fill if due date passes
I am trying to figure out how to have a "status" change to past due if the due date occurs and the status is not "complete." Is there a way to do this? Thank you!
-
Automations
Hi, I have below automations set for a sheet that gets the values from another sheet by index(match) function, and that another sheet is being updated on a daily basis. As can be seen in this example, I'm trying to get only the newly received SOWs but couldn't quite manage to do it. I tried almost everything in the…
-
Automation of Status Drop Down at the Parent Level
Hi, I want to automate the status column of the parent row based on the child rows. For example, if all of the child rows are left blank or marked "Not Started," I want the parent row to read, "Not Started" Or if a majority of the child rows are marked "In Progress" and some are marked "Complete" I'd like the parent row to…
-
Unable to change cell with using an automation
I am trying to create an automation that changes a cell when another cell changes. For example: When status column field changes to On Hold, the Health column field is to change to the yellow circle (symbols option). It does not give me the option to select the Health field. Does it have to do with being a symbol?
