Smartsheet not Auto-Calculating
I have a sheet that I am using for metrics to feed a dashboard. The sheet has formulas to summarize data as needed. The formula is linked to the results sheet for surveys. As new survey feedback is received, the formula in my metrics sheet is not updating. The formula worked initially, pulled necessary data, and populated on my dashboard. Now it's like the formula is static and not changing. I've saved the other sheet, refreshed all smartsheet items, I'm not really sure where to go from here. If I can't get the formula to automatically update, this is all kind of useless. Any help would be awesome!
Help Article Resources
Check out the Formula Handbook template!