Can I make an IF reference in another sheet and then Index / Match?
Hi!
I'm trying to make an IF formula that will look to see if a specific type of equipment is ordered, and if the PO has been issued, then move the checkbox to another sheet with Index / Match.
Here's a simpler one without the IF...
=IFERROR(INDEX({2024 GC and Contractor Sheet - Bids Range 1}, MATCH([WBS@row], {2024 GC and Contractor Sheet - Bids Range 2}, 0)), "")
Thanks!
Rose
Best Answer
-
Try an IF/COUNTIFS instead.
=IF(COUNTIFS({Vendor}, @cell = "Gilbarco", {Checkbox}, @cell = 1)> 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!
Answers
-
Are you able to provide some screenshots for context?
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!
-
Sure - I hope this helps...
Source Sheet:
If the Vendor is Gilbarco
And the PO Issued is checked....
In the sheet that will receive the IF / Index / Match
The GVR PO Issued checkbox should populate.
Thank you!
-
Try an IF/COUNTIFS instead.
=IF(COUNTIFS({Vendor}, @cell = "Gilbarco", {Checkbox}, @cell = 1)> 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!
-
Woo hoo! That does the trick thank you so much, Paul!
-
Happy to help. 👍️
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!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!