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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!