if() ex 3
Formula Example Supporter
description
Uses a checkbox property as a condition and returns values based on its state.
example tags
formula
if(prop("Task Complete"), "Complete", "Incomplete")
-
Suppose there is a checkbox property called “Task Complete.” If it is checked (true), it will return “Complete”; if it is not checked, it will return “Incomplete.”
-
Here, assume that the Task Complete property is marked checked.
linked blog post
results
Complete