Portfolio Metrics and Dashboards
Hey all! I just presented the new dashboard solution to the leadership team when I noticed the dashboards aren't picking up anything from the meta data sheet (which in combination with our intake sheet) creates my weekly status report template.
Any reason you guys can think of that would make all of my formulas freak out by changing the reference to the meta data sheet? Seems like it just does not want to acknowledge it's existence. Apologies for the muddled brain, but here's an example:
When the formula references the Intake Sheet, it results in a number, but it's wrong. When I try to make the formula reference the Metadata, I get unparseable.
Intake Formula:
Meta Formula:
Best Answers
-
Boy do I wish I had a fantastic lesson learned to share- but to be honest, I just made a copy of sheet where all the other formulas were working accurately rewrote all the ones that weren't from scratch- then spent until about 5:00 this morning doing stare and compare checks on all the reports and dashboards. I'm sure there's an easier way, but frustration with myself for messing it up in the first place and stubbornness to get everything back to the starting line was about it. LOL Now at least I am ready to complete my other dashboards this weekend and maybe even give the new Work Apps preview a spin! Thanks again for replying in my hour of need tho, deeply appreciated!
-
You're more than welcome!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Answers
-
Hi @Cat Werbeck
Have you looked at both of the sheets after errors in the ranges?
I hope that helps!
Be safe and have a fantastic weekend!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Hey there, yes- I have been staring and comparing for what feels like forever- I actually just figured out the solve. Took longer than I would like- but ty so much for answering!!
-
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Boy do I wish I had a fantastic lesson learned to share- but to be honest, I just made a copy of sheet where all the other formulas were working accurately rewrote all the ones that weren't from scratch- then spent until about 5:00 this morning doing stare and compare checks on all the reports and dashboards. I'm sure there's an easier way, but frustration with myself for messing it up in the first place and stubbornness to get everything back to the starting line was about it. LOL Now at least I am ready to complete my other dashboards this weekend and maybe even give the new Work Apps preview a spin! Thanks again for replying in my hour of need tho, deeply appreciated!
-
You're more than welcome!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
@Cat Werbeck how did you solve this problem, I am having the same problem after my new control center was set, it worked for 2 weeks and now, not all cells are showing information. Same as your problem. How did you fix it, I have been trying to link each sheet again to each line, but this is a lot of work for every new project that comes in.
your help is very much appreciated. Thanks Anita
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!