Create a Column =Original sheet name ?
Hi,
I have made a "Complete sheet" where I am using automated workflow (Move to another sheet when Status= Complete) to compile all my completed tasks from a few other sheets. I would like to sort them in the new sheet by which sheet they came from. As an example, I work on a few different segments- Hospitality, Builder, etc. so these are the names of my sheets. Is there a way to create a column in the new sheet, that populates the row with the sheet name of where is came from? (Column would say "Hospitality, Builder, etc)
Thanks!
Best Answer
-
You can easily populate the value using the Change Cell Value automation. When a new row is added, change the value in the "Source" column to the desired value. See help article:
Change a cell value with an automated workflow | Smartsheet Learning Center
Hope this helps!
Answers
-
The easiest approach would be to add a column called "Source" to each of your other sheets. Populate the entire column in each sheet with its location (e.g., every row in the "Source" column within the Hospitality sheet would say "Hospitality" and every row in the "Source" column within the Builder sheet would say "Builder.") After these new columns are in place, the first time a row is moved from any sheet, the "Source" column will appear in your Complete sheet. Then you can sort rows on the "Source" column in the Complete sheet.
Hope this helps!
-
@Anna.Morello did this work for you?
@Kelly P. is there a way to ensure this column is always populated? I don't see a function called "Source". I am doing essentially the same thing as Anna but every time a new column is inserted that row in the "Source" column is blank. A reference to the name in another column works for one cell but when I try to convert to a column formula th re is an error for syntax. Looking for a way to make this automatic.
-
You can easily populate the value using the Change Cell Value automation. When a new row is added, change the value in the "Source" column to the desired value. See help article:
Hope this helps!
-
thanks @Kelly P. ! That worked after a few tries! Appreciate the response.
-
@Megan Finn Happy to help!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
