IF formula

SmartsheetRookie · 05/24/22

Hi,

I need a cell A to be checked if another cell B states a specific word.

What would be the formula for this?

Thank you.

Shimanta Roy · 05/24/22

Try this one in column A:

=IF(ColumnB@row = "Your specific word", True, False)

Make sure your column A is defined as checkbox.

Shimanta Roy · 05/24/22

Try this one in column A:

=IF(ColumnB@row = "Your specific word", True, False)

Make sure your column A is defined as checkbox.

SmartsheetRookie · 05/31/22

Thank you this worked. How should I modify if I need more than one specific word?

Best Answer