HAS

Checks if a cell contains a specific value. Essential for Multi Select dropdown columns — CONTAINS checks text substrings, but HAS checks for exact option values.

Syntax

smartsheet-mastery

=HAS(@cell, "value")

Example

smartsheet-mastery

=HAS([Tags]@row, "Urgent")          // True if "Urgent" is one of the tags
=IF(HAS([Skills]@row, "Python"), 1, 0)
=COUNTIF([Tags]:[Tags], HAS(@cell, "Leadership"))