I have a first sheet that was filled out by people using a smartsheet form to populate a sheet for a certification program. A second program is only open to the people who were already certified in the first program, so they fill out a Smartsheet form with minimal fields, include a unique ID number, and the rest of their info pre-populates from the first sheet using formulas, which is great until I try to make summary data/dashboard info from the formula-pulled data.
Specifically I pulled their Division from the first sheet to the second one. I want to know how many people from each division (division is pulled by a formula) signed up for the second program and to include it in a dashboad. I wrote summary formulas (e.g.,
=COUNTIFS($Division:$Division, "Library/Learning Resources")
Then I added that summary data on a dashboard. On my work computer or the downloaded version of Smartsheet-all the summary results for each division say "NO MATCH" On my home computer, they work and give totals. So I never know when I show to managers if it will actually show the data or look broken, or what the managers will see if I share the Dashboard link. why does it work, but only sometimes? I haven't figured out another way to summarize the data.