Automate the Progress Bar Based on CountIF of a selection in a DropDown
Hi there,
I want to COUNTIF the cells in each column are green 'Checked Ok' and adjust the progress bar based on the number of these. Any help would be very gratefully received! ty
Answers
-
I have the first part - =COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") - I just need to know how to connect this to the progress bar....any ideas? ty!
-
I hope you're well and safe!
Try something like this. (update to match your needs)
=
IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") = 1, "Quarter", IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") = 2, "Half", IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") = 3, "Three Quarter", IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") = 4, "Full", "Empty"))))
Did that work/help?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
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.
-
It has parsed fine, but the progress bar is at 0 - I put the formula in the same cell as the progress bar - is that correct?
Really appreciate the help btw!
-
Actually - if all are marked as checked ok - then the progress bar is full, if I choose another selection (there are 3) then the progress bar goes to 0....so, it is working, but not entirely as expected....
Other selections are Issues Raised and Show Stopper
-
Happy to help!
You need to account for all options, either with more than, equal to, or each option added.
Make sense?
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.
-
It makes sense, but not sure I know how to do that....would you mind starting me off? thanks ever so much!!
-
You're more than welocome!
I'd be happy to take a quick look.
Can you maybe share the sheet(s)/copies of the sheet(s)? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)
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 can't as this is our company smartsheets, so it is totally locked down.... anything I can try from my side?
Thanks again!
-
Can you paste your formula and some screenshots instead?
You can send it to me as well.
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.
-
The view of the progress bar when all are Checked OK, but one isn't.
Below is the view of the progress bar once that one item is marked as Checked Ok
The formula is:
=IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") = 0, "Empty", IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") >= 4, "Quarter", IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") >= 7, "Half", IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") >= 11, "Three Quarter", IF(COUNTIF([Wide View]@row:[Bingo On App Android]@row, "Checked Ok") >= 14, "Full")))))
All items in the row are marked Checked Ok and the formula returns the progress bar like this:
Is this enough info?
Thanks!
-
i feel like im almost there, but the logic is not quite right....
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!