There you go! You now have the 6 formulas which can be accessed anywhere in your document for quick filtering, automations, etc. Just make sure you name each formula in the opened formula so that you can access them in your document!
Read on to see an example use case
Example Use Cases
Let’s say you are building a project management document where each project has associated tasks with a targeted start date. It might be natural to have a couple different views of each projects tasks.
You may want to create a view looking ahead to see what specific tasks you have in the upcoming week.
Currently, Coda provides some helpful filters as seen here
There are some options available — but not extensive
Unfortunately there is no option to choose the next week only the next 7 days. Now that you have your formulas written and referenced in the canvas you can do this: