I notice the project summaries on a couple of my landing pages went sideways. It appears the RYG column to the left is the culprit. What happens is my R, Y, G, GR columns out to the right will appear as INVALID as opposed to populating the totals. After some troubleshooting I realized the only thing that works to correct it is to reset the RYG column formula to the left, and the individual R, Y, G, GR columns out to the right will then populate correctly. This is what drives the project summary widget on the on the landing page. By reset I mean copying the RYG formula on the left from the top row, deleting it, saving, and then pasting it back in and pulling it down through all the rows. We've had these sheets set up forever, and I experienced the same issue on an entirely different project sheet about a month ago. Any idea? Is this a Smartsheet blip? Smartsheet doing upgrades, or bug fixes that might affect the behavior? I didn't take a screen shot prior, when INVALID showed up in the count columns to the right, but this is the correct look, since I corrected it. I also attached a snippet of the project summary from the landing page, which is reflected correctly. This morning, prior to my fixing the sheet issue, the widget showed as no data source. Thank you!
Michele
