Is there an issue with using an IF statement across multiple sheets?
Hello,
I am having trouble using an IF statement across multiple sheets.
Basically, IF a row has a specific word, it should pull the column I need. Or was there never a link like this before?
Thank you!
Answers
-
Do you know if this works with columns that have the checkbox property?
I am looking for a checked box to bring data into a new sheet.
Thanks!
-
@Desiree500 Sure, just make your IF statement check to see if that box is checked on. If it is, then go get your data. If it isn't, do nothing.
=if(Checkbox@row = 1, do the index/match thing, "")
-
Thank you!
And going even further with this, can you nest index/match with index/distinct & an if statement?
-
@Desiree500 What are you looking to do with it nested? Can you give me a little more context?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 219 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!