Reference Formula Across Sheets

Hello,

I have been working with this formula below in order to search multiple sheets to see if a name has been submitted before. The formula is currently in a checkbox format and I keep getting the error "Boolean Expected". I think it wants to display a number but what I want it to do is check the box if it has appeared on any of the other sheets.

=IF(COUNTIF({Sample Range 1}, [Name Field]@row) > 0, 1, 0) + IF(COUNTIF({Sample Range 2}, [Name Field]@row) > 0, 1, 0) + IF(COUNTIF({Sample Range 3}, [Name Field]@row) > 0, 1, 0)

Any suggestions?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!