Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
I'm hoping to find a formula I can use to automatically fill out the parent row's progress bar based on the child rows. The result would look something like this, just not sure if this is possible.
Thanks so much!
Since the Progress Bar is a text based field where if you type "Half" the 50% Progess shows, there wouldn't be an easy way to do this. You could create a numberical column next to it that would convert "Half" to 50% with an IF statement, but if you got any inbetween percents you'd have issues.
While not a progress bar, the main sheet I use, uses just percent complete where it divides the count of completed Children (by a checkbox, which is 1 or 0, checked and unchecked) by the count of total Children. This seems to work pretty well.
If you do find an alternative, I'd love to see how you get it working.
Good luck!
