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!