=IF statement referencing an entire column
Hi community,
I'm wondering if there is a way to build an =IF formula while referencing an entire column. for example:
=IF([any value in column B]=A1, true, false)
Thanks!
Best Answer
-
The formula is totally possible! To reference an entire column just use [Column Name]:[Column Name]
You might need to do something like
= IF(CONTAINS(A1, [Column B]:[Column B]), 1, 0)
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| senior systems analyst | global growth & concepts
Answers
-
The formula is totally possible! To reference an entire column just use [Column Name]:[Column Name]
You might need to do something like
= IF(CONTAINS(A1, [Column B]:[Column B]), 1, 0)
Kelly Drake (she/her/hers)
STARBUCKS COFFEE COMPANY| senior systems analyst | global growth & concepts
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!