check box formula

C. Srinidhi Ragunathan

Hello I am trying to do the following on my smartsheet. I have two columns : the first one with a checkbox format and the next column indicating the % completed.

I want to create a condition such that, if the check box is ticked, the % complete indicates 100% else 0%(if not ticked).

 

I used the following equation: IF(COL1 = 1, 100%, 0%). However it is not getting parsed.

Kindly let me know if this is the right way to go about .

 

Thank you

Andrée Starå

Hi,

Unfortunately. You can't have formulas if the % Complete is a % Complete column in the Project Settings. If it's a standard column formatted with percent you'd use the formula below.

=IF(COL1 = 1, 1, 0) Percent is written as 1 = 100% 0.5 = 50%.

More info:

https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors#Complete

https://help.smartsheet.com/articles/518246-formatting-options

Use Percentage Format percent-button to treat numbers as percentage of 1. If you format a cell this way, the value 0.95, for example, will be is displayed as 95%. The value 95 will be displayed as 9,500%.

Hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Paul Newcome

Andree: Not having formulas in the % Complete column is only applicable if you have dependencies enabled.

 

If dependencies are not enabled you have two options.

1. If you are just going for a visual display, then you should be able to use your current formula so long as the column name is correct.

2. If you are planning on using the percentages as a number, you would need to follow Andree's suggestion of referencing the percentage as a fraction of 1 and then set the column to percent format.

Andrée Starå

Paul,

Yes, certainly and I assumed that was the case because it is most of the time. Good catch!

Kind regards,

Andrée

Paul Newcome

I personally almost never use dependency settings because of the lack of flexibility, so I am the opposite in that I forget about the restrictions of having them on. Haha

Andrée Starå

That makes sense! 

Best,

Andrée