can i auto-populate/create rows on another sheet if a cell on another sheet changes?

In this case, I'll populate a scheduling sheet as seen on top, this will then ideally show up on the 18th of Dec (if it's scheduled on the 18th) as separate rows if possible. Not sure if smartsheet is able to do something like this so would like to get possible help or input?
So far i've tried using smth like
=IF(OR(CONTAINS("Truck In", {xxx1}), CONTAINS("Replacement", {xxx1}), CONTAINS("Truck In/Out", {xxx1})), INDEX({Date}, MATCH("Truck In", {xxx1}, 0)), ""); which does update ONE cell but it doesn't work when I apply it to the 2nd column because my truck schedules are all in columns but in one row im assuming it doesn't create more rows
Answers
-
Hi @leoc
The solution I came up with uses workflow automation.
- When one of the hose columns in the Scheduling request sheet changes to one of the three work type values, "Truck In," "Replacement," or "Truck In/Out," the cell values of a helper column in the [Scheduled Hose] dropdown list are changed to one of the hoses.
- When the [Scheduled Hose] value changes, copy the row to another sheet, Scheduling Sheet, in my example.
- With the new row copied, update the description primary column with a formula that combines the [Scheduled Hose] value and one of the three work type values like "Truck In."
Scheduling request sheet
Workflow Automation
Copy rows automation
Change cell value automation (Example 1)
Scheduling Sheet
The Scheduling Sheet has this formula in the Description column.
[Description] =[Hose Scheduled]@row + ": " + IF(CONTAINS("Plot 1 RO", [Hose Scheduled]@row), [Plot 1 RO Con Tank NHW (3inch hose)]@row, IF(CONTAINS("Plot 1 Aeration", [Hose Scheduled]@row), [Plot 1 Aeration Tank (1.5inch Hose)]@row, IF(CONTAINS("Plot 2 CHW", [Hose Scheduled]@row), [Plot 2 CHW (3inch hose)]@row)))
The IF part of the formula chooses one of the three columns to show which work type to add to the description.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives