How can I chart the last 7 days that contain data?

JBalow ✭✭✭
edited 09/06/22 in Formulas and Functions

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.



Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!