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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!