Countif and countifs not updating

Rob Pritchard

I have created a smartsheet with a number of different formulas in to pull together monthly figures. I then use this information to populate charts in my sights. One view I use is to count the number of new jobs added each month. This was working great until latest update.

When I look at my sight the chart is no longer there and says source data file removed. I go into the smartsheet and see invalid data type error. Click in the sheet and the data refreshes and displays itself. Go back to sight and chart now works.

 

Carry on using smartsheet revisit sight same problem loss of data.

 

Sumifs on the same sheet work perfectly all the time?

Shaine Greenwood

Hi Rob,

Contact our Support team to further troubleshoot the issue that you're experiencing with your Smartsheet dashboard.