CRUSJ✭

@Paul Newcome Thank you Paul! That works. I must have been doing something wrong with the transition between the two columns.

@Paul Newcome So that works for my chart, I got rid of the No Data to Display error. Thank you! I had made a copy of the sheet I was working on but I didn't update the chart with the report for the duplicated sheet. So it was still pulling from the original report. But now I cant get my widget to display just a 0 instead…

Hi Paul, So I tried both of those. Wrapping it in a =SUMIF did not make any change. Adding the decimals ends up reporting that score in another widget of the Dashboard like the picture, and that wont work. Plus, there are dozens of these dashboards. So far, only three of the dashboards are having this "No Data to Display"…

@Paul Newcome Hi Paul, here is the score formula and the columns that it is pulling from

Hi @Genevieve P. , I started working on this but am having trouble getting my sheet data put into it properly. I am trying to put it directly into the sheet just to ensure it works properly before I put it into the sheet summary. Below is the screenshot of the sheet.

@Genevieve P. Thanks for your reply! This would most likely be within a sheet summary so that it could be then correspond to a dashboard. Based on how you have your sheet setup, it seems like this would work. I will incorporate this into my sheet and then follow up with you after the holiday. Thank you so much for your…

@Paul Newcome Hi Paul, I had to take a break from this to refocus on some other priorities so I apologize for the late reply. Although you may have been happy to be done with this particular problem! I took that parentheses out but am getting Invalid Operation now. Here is the formula: =MAX(0, MAX(COLLECT([日付 Date]:[日付…

Hi Paul--I have attached a screenshot of the columns that I am working with. The date column is set to an actual date type column. The other two columns are just text/number type. The dates are being entered on the coinciding exactly as they appear here. In this example, I would want the [Formula Test] column to show a 2…

Hi Paul--I checked and the date column is indeed formatted to a date