Welcome!

check box formula

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

Find more posts tagged with

Comments

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

Sign in to join the conversation!

Quick Links

Trending discussions

Keep getting Selected data cannot be charted. Please select a new range.
Hello, I am trying to create a chart widget in my dashboard, but I keep getting "Selected data cannot be charted. Please select a new range." error. The report I am using is already summarized in numeric value. What is funny is I have report that I created a chart widget in another dashboard, and when I use that same…
Countifs formula to count based on two columns
I have a picture below for an example of this. I want to create a formula to get counts of items in "Column2", but if "Column4" states "change" I want the "Column2" count to not work and instead count what is it "Column3" in that given row. Column4 can also have several different things in it besides "good" that I want it…
Is there an issue with using reports on a dashboard to create a graph?
I've done this a million times - create a report, separated by campus with a total $$. Then add it to a dashboard and make a graph. NOTHING is working right now when I try to do this. I get an error that the data cannot be charted. What the what? Help anyone? Is this a issue since they apparently changed something in the…