Check all related checkboxes
Answers
-
I have a similar, but slightly different application. Is there a way that when the checkbox in "Include in Pitch?" is selected that all other "Sales Orders" with the same Sales Order number could have their checkbox checked automatically? I tried various Index(Match, Index(Collect formulas and couldn't make it work. I added some helper rows as well from different threads, using Vlookup on "Row@row-1" but couldn't get that to work either.
-
You would need a helper column with the following column formula:
=IF(COUNTIFS([Include In Pitch?]:[Include In Pitch?], @cell = 1, [Sales Order]:[Sales Order], @cell = [Sales Order]@row)> 0, 1)
Then you would set up a Change Cell automation set to trigger when this helper column changes to a 1 it will change the value in the [Include In Pitch?] column.
-
@LakeWaconia Please see above.
-
Thanks Paul. That worked awesome. Sorry about the double-post. My screen refreshed and didn't see my post. I thought I forgot to hit "Post Comment"
-
No worries. Happy to help. 👍️
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.4K Get Help
- 394 Global Discussions
- 213 Industry Talk
- 449 Announcements
- 4.6K Ideas & Feature Requests
- 141 Brandfolder
- 132 Just for fun
- 131 Community Job Board
- 453 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!