Group and filter by "customized week"
#Formulaandfunctions #reportsandcharts #Formulasandfunctions Hello I would like to get assistance on how to group and filter records based on particular criteria: workweek from Wednesday to Tuesday....
Forum Discussion
MarkShnier__You
Qrew Legend
Qrew LegendOu will need to create a text field which calculates to the choices that you want. Then use that text field as a Dynamic Filter.
Post back if you ned help on how to write the formula being very clear how you want the text to read (or maybe you want it similar to the screen shot and if so, at what point if any, do the dates get grouped in "really old" or "really far ahead".
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Post back if you ned help on how to write the formula being very clear how you want the text to read (or maybe you want it similar to the screen shot and if so, at what point if any, do the dates get grouped in "really old" or "really far ahead".
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
- Thaqnks a lot Mark :)
Yes, reading them as the screenshot will be ideal. 6 months back will be sufficient for the calculations I am planning.
Kind regards,
------------------------------
Sergio Sanchez
------------------------------
