check a box across on another sheet
I have a condition which is met on one sheet and I want to check a check-box on another sheet.
When a purchase request is updated in the {purchase request} sheet, column [vendor] = "LKQ" then check the box "Purchase requested" in another sheet the {Vendor Specific Sheet}.
Answers
-
Are you able to provide some screenshots for reference?
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
On the purchase request sheet
On the Parts Procurement report which feed the individual vendor reports:
I need a formula to change a cell in the Parts Procurement Report: If the Claim Number (Not visible) and the vendor "LKQ" match from one sheet to the other, then check the box in [Adjuster requested Part Purchased].
Thank you, Paul
-
Try this. Not 100% sure that does what you want it to.
Helper col. =if(vlookup([claim number]@row, purchase request sheet reference, vendor column, false)=vendor column on procument sheet,"true","false")
-
ignore the helper column requirement at the beginning of the formula - rewrote to not need it. sorry
-
Since you want to match on two separate criteria and you are only wanting to check a box, you can use a COUNTIFS to find how many rows have the matching vendor and claim number. Then drop that into an IF statement to say that if that count is greater than zero, check the box.
=IF(COUNTIFS({Source Sheet Vendor Column}, @cell = Vendor@row, {Source Sheet Claim Number Column}, @cell = [Claim Number]@row)> 0, 1)
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
Thank you for your help Paul. I will let you know.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 302 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!