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
Comments
-
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/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.
-
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.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
-
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
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 377 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 289 Events
- 33 Webinars
- 7.3K Forum Archives