Formula # UnParseable?

maynardg

I have a Smartsheet 4 columns are check boxes.

I want the check boxes to change a list column to the following.

If I check on Assigned then change list to Assigned

If I check on In Progress then change list to In Progress

If I check on Holding-See notes then change list to in Progress

If I check on Complete then change list to Complete

Here is the formula

=IF(Resolved@row = 1, "Complete"), IF(In Progress@row = 1, "In Progress")), IF(Holding-See notes@row = 1, "Holding-See notes")))

Bassam Khalil

Hi @maynardg 

Hope you are fine, please try the following formula and convert it to column formula:

status = =IF(Resolved@row = 1, "Complete", IF([In Progress]@row = 1, "In Progress", IF(Assigned@row = 1, "Assigned", IF([Holding-See notes]@row = 1, "Holding-See notes", ""))))

the following screenshot show the result

Bassam Khalil

Hi @maynardg 

Hope you are fine, please try the following formula and convert it to column formula:

status = =IF(Resolved@row = 1, "Complete", IF([In Progress]@row = 1, "In Progress", IF(Assigned@row = 1, "Assigned", IF([Holding-See notes]@row = 1, "Holding-See notes", ""))))

the following screenshot show the result

maynardg

Thank You! It works...

Bassam Khalil

@maynardg 

You are welcome