How can I chart the last 7 days that contain data?
Hello, I am capturing audit data utilizing the web form for smartsheet, and would like to use a line chart to show average compliance per day, for the last 7 working days. With the holiday weekend that just occurred, I have a 3 day hole in my chart.
I have been brainstorming and am trying to come up with a formula that will first check if there is data on the current date, then evaluate the previous date for data, and so on until there are 7 days with data.
I am fairly new to Smartsheet and am brushing off the function cobwebs, so any help would be appreciated.
Help Article Resources
Check out the Formula Handbook template!