check box formula

Options
edited 12/09/19

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

• ✭✭✭✭✭✭
Options

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%.

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

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

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.

• ✭✭✭✭✭✭
Options

Paul,

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

Kind regards,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

• ✭✭✭✭✭✭
Options

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

• ✭✭✭✭✭✭
Options

That makes sense!

Best,

Andrée

SMARTSHEET EXPERT CONSULTANT & PARTNER

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.