Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Parent Relation on Progress %
Hi,
i am trying to figure out how to create a parent relationship using the progress bar (0%, 25%, 50%, etc...) without having to enter 2 dates.
I have a parent with 6 children rows under it. If i choose the progress bar as a colum property from symbols and select progree in the 6 children, I want the average to be displayed in the parten. Again, without using a start and end date.
Thank you in advace for your help.
L.R.
Comments
-
Hi Laurenz,
Great question.
What I had to do to get this to work is create another column to extrapolate the percentages - here is the formula to do that:
=IF(Status2 = "Empty", 0, IF(Status2 = "Quarter", 0.25, IF(Status2 = "Half", 0.5, IF(Status2 = "Three Quarter", 0.75, IF(Status2 = "Full", 1)))))
Then, in the parent row, I created an average (column is formatted for percentages):
=IF(AVG(CHILDREN()) = 0, 0, AVG(CHILDREN()))
You can take a look at the sheet here.
Please let us know if you have further questions!
Best,
Kara
