I have a table of boat maintenance tasks. Each task includes a Frequency field. Task frequency values can be set to one of each of the following values: Weekly, Bi-Weekly, Monthly, Each Spring, Each Summer, Each Fall, Each Winter, Every Other year. Each task also has a Last Completed date field. I'd like to make a table view that lists all the tasks that need to be completed in the next 30 days.
It's easy enough for the tasks with duration-based frequency (eg weekly), but I'm quite frustrated in my attempts to find a combination of formulas, fields, filter or other mechanisms that can enable me to generate a consolidated list of tasks that are due in the next 30 days. (FWIW, the same task took me 10 minutes to complete in AirTable, btw, but for other reasons, I'd prefer to build this in Knack.)
Thanks in advance for any recommendations!