Cross sheet formula to pull in value
I am trying to write a formula that looks at another sheet, looks at 1 column if the column is NOT equal to 0 then it would pull in a different column's cell information.
=IF(INDEX({Job Intake Form - Fence Range 1},1){Job Intake Form - Fence Range 2}>0)
This is what I was thinking {Job Intake Form - Fence Range 1} references the column that I want the information to copy to my sheet, and {Job Intake Form - Fence Range 2} looks at the column to evaluate if it is greater than 0. Am I on the right track here? Any help is greatly appreciated.
Answers
-
So you want to bring in from Range 2 if Range 1 is not equal to zero?
-
I want to bring in the information from range 1 if the information in range 2 is not equal to 0. Do I have my formula set up backwards?
Thank you for your help.
-
Your most recent description is the opposite of the original description. Give this a try:
=INDEX(COLLECT({Range 1}, {Range 2}, @cell> 0), 1)
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 409 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!