-
Copy and duplicate Rows based on value in cell
Hi there, I have the issue where a user is attempting to duplicate the cell value within a sheet, based on a trigger, and a quantity. For example: Form intake produces a row with the values Column: Status = "Requested" Column: Quantity = "3" Column: CODE = "ABC" I would like when the Column: Status changes to "Published",…
-
How do I move certain values from one sheet to a different sheet?
My attempt: Step 1: Sheet #1 get populated with new values (via a form submission(s)) Step 2: When Sheet #1 has a new value/row, only certain columns get populated into Sheet #2(i.e. ID number, case name, details) I tried the automation feature, but the whole row gets copied. I want it so that only certain…
-
Copy row automation is not copying all data (assigned people in contact list row)
We have a 'copy rows to another sheet' automation that is working correctly except for one column, the "assigned to"/contacts column has stopped copying the data. It was working well until last week. No changes to the automation took place. I removed and re-added the automation and confirmed no automations in the…
-
How to automate or move cell values when a date is in the past week?
Here is a tracker of a 10-weeks look ahead of number of hours to spend in project from Monday-Friday which are highlighted in blue cells. The Start Week and End week changed if a date is based on current week. Which means 9-Jun-2024 will be the current week by next week , correct? The problem now is the no. of hours is…
-
Trouble copying formulas into new sheet
Hello All! I am having difficulty copying formulas from one sheet to the next- I keep getting "UNPARSEABLE". I have tried copying/pasting in multiple ways, no luck. Details: Formulas look like =COUNTIFS(Type:Type, "GC", Team:Team, "TM") , "Type" and "Team" being columns in each separate monthly sheet. If the columns are…
-
Merged: Copy cell value(s) to another one if value/specific value is input in a specific cell
This discussion has been merged.
-
Moving Rows between sheets
Hi! I have a Original sheet with data being inputted by different users and locations. I was trying to build out reporting so I moved one locations data to another sheet. Is there any way to move it back to the original so I can change it to copy rows to the secondary sheet instead? I don't want to risk losing all the…
-
Auto populating Rows based on the number in the Qty box
Hi. Is it possible to auto populate rows based on the number I have in my QTY cell? I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or…
-
Copying Data from Locked Cell as Editor
My team is looking to lock a cell so that only admin's and owners can edit the column, but we need our other team members with Editor permissions to be able to at least copy and paste the cell and have the data move with it to a new row. Currently, an Editor cannot copy the cell and paste and have the data show up in the…
-
How to copy form to create its new a bit different version
Dear All, I created a form in Smartsheet that is quite complex and I would like to create similar version of the same form but with some additional options to see what version will be better for my needs. As I don't want to start from scratch with this new version of the form, is it possible to copy ma first form and just…