Ben SmithBen Smith
Ben Smith/
Incomplete Tasks
Incomplete Tasks
Incomplete Tasks

Incomplete Tasks

For
Carl, Russell
From
Facebook
Status
Updating
Formulas
==
==
if
if
replaceAll
replaceAll
!=
!=
Share

With Checkboxes

Projects
Tasks

Tasks → Incomplete

prop("Complete") ? format(toNumber("")) : prop("Name")

Tasks → Incomplete (•)

prop("Complete") ? format(toNumber("")) : ("• " + prop("Name"))

Projects → Incomplete List

replaceAll(prop("Incomplete (•)"), "[,^]", "\n")
👆
This replaces the commas in the Incomplete (•) comma-separated list with line breaks.
 

With Statuses

Stats
Modules

Modules → Not Submitted

if(prop("Status") != "Submitted", prop("Name"), format(toNumber("")))

One Database

Tasks

Incomplete

if(not prop("Complete"), prop("Name"), format(toNumber("")))
 
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!