How to Auto-Update Progess Bar

mlamb

I need assistance with the appropriate formula to automate progress bar changes. I have attemped the formula I have seen in other posts, but I am getting error "unparseable"

Dan W

add @row on [% Complete]

[% Complete]@row

That might fix it

mlamb

Thank you! Thank in conjunction with taking out the "%" and making them all decimals did the trick!

Dan W

I was just about to say that as well! Glad to help, I'm going to post the completed formula just incase anyone else stumbles upon this thread

=IF([% Complete]@row < 0.25, "Empty", IF([% Complete]@row < 0.5, "Quarter", IF([% Complete]@row < 0.75, "Half", IF([% Complete]@row < 1, "Three Quarter", "Full"))))