Countif and countifs not updating

Rob Pritchard
Rob Pritchard ✭✭✭✭
edited 12/09/19 in Formulas and Functions

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!