Automate the Progress Bar Based on CountIF of a selection in a DropDown

Miranda Rais

Hi there,

2021-06-09_23-12-37.png

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

Miranda Rais

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!

Andrée Starå

Hi @Miranda Rais

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!

Miranda Rais

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!

Miranda Rais

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

Andrée Starå

@Miranda Rais

Happy to help!

You need to account for all options, either with more than, equal to, or each option added.

Make sense?

Miranda Rais

It makes sense, but not sure I know how to do that....would you mind starting me off? thanks ever so much!!

Andrée Starå

@Miranda Rais

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)

Miranda Rais

I can't as this is our company smartsheets, so it is totally locked down.... anything I can try from my side?

Thanks again!

Andrée Starå

@Miranda Rais

Can you paste your formula and some screenshots instead?

You can send it to me as well.

Miranda Rais

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!

Miranda Rais

i feel like im almost there, but the logic is not quite right....