Is there an easier way to add a filter with days instead of dates?

Doug_Doug_aus2_G9

I currently have a line chart widget that tracks count of a value weekly. The only problem is that our week starts on Friday, ends on Thursday of the following week.

I have set up helper columns with a formula =WEEKNUMBER([NEO date scheduled]@row) but on every Friday, i have to change =WEEKNUMBER([NEO date scheduled]@row) + 1. I though setting this on change cell value automation for Friday only, but smartsheet doesnt seem to add formulas on automation.

If there is not an available feature to set a filter range for days, hoping it can be a feature added?

Humashankar

Hi @Doug_Doug_aus2_G9

Yes - you are right.

II is not an available feature to set a filter range for days, to request a feature added, kindly make use of the navigation - Smartsheet Product Feedback

Hope this helps - Happy to help further!!

Thank you very much and have a great one!

Warm regards