Automating check box for multiple values

jackie.affayroux33831

Hi,

I need help writing the formula to automatically check the box when any one of these three values is selected:  Complete,  Cancelled, or Passed_Conditionally.

Thanks!

Robert S.

Hello,

 

Thanks for the question. This can be done using the IF() and OR() functions. More on all of the functions Smartsheet offers can be found here (https://help.smartsheet.com/functions). Here's an example of how this could look:

 

=IF(OR([Status Column]# = Complete,  [Status Column]# = Cancelled, [Status Column]# = Passed_Conditionally), 1, 0)

 

To make this work for you, replace [Status Column] with the name of the column that the values are in, and replace the # with the row number you're placing this formula in. Once it's working in one row, you can drag-fill this down the column for any other rows you need this in. More on drag-fill can be found here (https://help.smartsheet.com/articles/518318#dragfill).