Sheet Rollup - Formulas Referencing Other Sheets
Hi,
I have a sheet to rollup metrics, and would like to reference another sheet but still am getting unparseable error. The formula is this to make a distinct count for accounts. See screenshot
=COUNT(DISTINCT({SY22-23 LS TV Contract Renewals & Price Account}:{SY22-23 LS TV Contract Renewals & Price Account}))
And another formula is this to make a percentage of those complete based on the reference sheet's health. See screenshot
=COUNT(DISTINCT(COLLECT({SY22-23 LS TV Contract Renewals & Price Account}:{SY22-23 LS TV Contract Renewals & Price Account}, {SY22-23 LS TV Contract Renewals Health}:{SY22-23 LS TV Contract Renewals Health}, @cell = "Blue"))) / [Total Account Renewals]@row#
Can someone please assist?
Answers
-
When you have sheet reference, {SY22-23 LS TV Contract Renewals & Price Account} you should be selecting the column or field you want to include, so you don't need to add a colon :
Try this:
=COUNT(DISTINCT({SY22-23 LS TV Contract Renewals & Price Account}))
-
Thank you for your help!
Help Article Resources
Categories
Check out the Formula Handbook template!