Date Calculation for Formula Checkbox field
I am trying to build out a To-Do app, and I want to sort by Tasks that have a due date within 7 days of the current date. My idea was to create a Formula-Checkbox field with an if/then statement that...
Forum Discussion
I'd recommend using the filters and grouping options to actually key off the 'Date' rather than a yes/no checkbox.
If gives the user a better experience to have it sorted by dates, and then grouped by weeks (thus your 7 day windows). Acts as a better 'priority' based to-do list.
If gives the user a better experience to have it sorted by dates, and then grouped by weeks (thus your 7 day windows). Acts as a better 'priority' based to-do list.