How do you show a roll-up percentage for Children Rows that are percentages

LisaKM

LisaKM ✭

05/09/24 edited 05/09/24 in Formulas and Functions

I can't seem to get this to work correctly. I've tried a few different formulas.

Screenshot 2024-05-09 at 5.37.00 PM.png

0 ·

Answers

Gia Thinh ✭✭✭✭✭✭

05/10/24

Hi @LisaKM
Go to Project settings and enable Dependencies as the screenshot below to make the parent's percentage work. Hope it works for you.

Gia Thinh Technology - Smartsheet Solution Partner.
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!
Reverse engineering a cell reference formula
Hi, Smartsheet developed a solution for my current employer before I started here. I'm an Excel power user and in the process of becoming a SS resource for this employer. That said, I feel really silly but cannot figure out what's going on in this cell. It looks like a cell or column reference but the column doesn't appear…