<aside> ✅ Here you’ll find all of the formulas that are used within Ultimate Tasks. Included is a filtered database showing the tech reference pages for each formulas; below that, you’ll find a list of the formulas in the order that they should be created if you’re building Ultimate Tasks from scratch.
</aside>
<aside> ⚠️ If you’re following my 2020 Task Manager build guide on YouTube (the old one), use the formulas in 2020 YouTube Task Manager Wiki. The current version of Ultimate Tasks contains many changes and updates to those formulas.
</aside>
<aside> ⚠️
</aside>
<aside> ✅ If you’re building your own copy of Ultimate Tasks, use this section to copy and paste in all the formulas. This is the order you’ll need to create them in, as some of them depend on other properties to already exist and be properly configured.
If you get a Property Not Found error while pasting a formula, that’s an indication that you’ve done something out of order (or misspelled a property’s name).
You can copy each formula by hitting the Copy button in the top-right corner of the Code block. This is a more error-proof way of copying the formulas than highlighting the text.
</aside>
<aside> ✅ The following Formula properties must be created in the 📜 All Tasks database.
</aside>
These properties must exist first:
if(empty(prop("Parent Task")), "", "➞") + if(prop("Done") == true, "😀", if(empty(prop("Due")), "⚪️", if(formatDate(prop("Due"), "L") == formatDate(now(), "L"), "🟢", if(prop("Due") < now(), "🔴", "🔵"))))
Reference: State