Comments
-
Hello Kyle Gostinger, do you have an update after a few days of looking into this? This is affecting 100s of people in our organization (just in my circle of communication). Please provide a timeline so we can notify our teams of when this will be fixed. thank you.
-
Yup, same here. Have 12 dashboards shared globally that now have useless pie charts. There are typically a few fields with data out of ~50 possibilities. So only a few would graph. Now everything is there in the legend. One partial work around is to turn off the legend, so you have to hover to see the category. I'm hoping…
-
Paul, you rock. thank you. For whatever reason, when I copy/paste it didn't work. But when I slowly build each argument one at a time, it works. I probably had an extra (or missing) syntax somewhere.
-
I'm having the exact same problem, but using CONTAINS isn't working for me. Instead of looking for contains "text" search, I'm trying to look for contains {cell reference contents). The formula below works fine as long as the searched cell only contains one thing. If there are multiple options, it doesn't count at all.…
-
The blank row elimination from the referenced (view only) sheet, along with the addition of the ,0 at the end of the formula seems to have corrected the formulas, at least temporarily. It was good for about 30 mins until someone else added blank rows again. It'd be great to have a method to make the formula insensitive to…
-
here's a screenshot in the format this forum enjoys.
-
There WERE blank rows in the SS data we linked to. Also added the ,0 to the end of the equation: =INDEX({SPB 2019 CY Savings}, MATCH([SPB #]1, {SPB 2019 Range SPB}, 0)) Here's the rub. Initially after removing empty rows in the referenced sheet and adding the "0", the formulas worked correctly. 30 mins later values are…
-
Hello Andree, sadly that didn't work. I also tried no number, 2, -1.... Thanks for trying, but my problem persists. -Kyle
