Copy Rows automation isn't working how I want
Hello,
I am new to Smartsheet and so far I am loving it. However, as with learning anything new, I am running into some blocks that I need guidance with.
I created a portal where a "claim" can be submitted. I have the sheet setup to pull in up to 15 items. However, the claims dept wants a sheet that cascades the items per claim rather than listing the items from left to right.
How it is:
How I want it to be:
So the steps are that a customer will submit a claim to the main sheet. From there, I have a sheet(s) that does an Index formula to pull in certain fields.
Whats cool about this formula is that Claim number to Modified at updates as soon as a new claim is submitted. I first set the automation to "run" when the Claim Number changes, but that didnt work so I have more parameters setup to run.
I also have it setup to run when rows are added or changed. However, this is causing some duplication with the claim items.
Now the automation works if I drag the formula down and add more rows, but then the claims get duplicated which will not work.
What I am trying to achieve is when the claim number changes, then the automation occurs and copies to the correct sheet for each item that is on a claim. I feel like I am almost there but am missing something. Any assistance would be appreciated!
Answers
-
Automations cannot be triggered by a cell containing a cell link or cross sheet reference.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!