IF auto generated number in Row matches anywhere in 2 sheet columns then checkbox checked

Wes S
Wes S ✭✭
edited 12/09/19 in Formulas and Functions

Hello, 

I am trying to input a formula that automatically checks a checkbox when an auto generated number from a specific row in one sheet, is found anywhere in a column from 2 separate sheets. 

I've tried to make it work by referencing just one of the two sheets but it is behaving strangely. 

 

The formula I tried is =IF(MATCH([Lead ID]1, {Construction/Enhancements Estimate Workshe Range 1}, 0), 1, 0)

If I drag the formula down the checkbox rows and populate the referenced sheet with matching Lead ID's I get a checked box on my first row and INVALID DATA TYPE on any others that should match. 

Thanks in advance for any help you're able to give.

Tags:
«1

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!