Ben SmithBen Smith
Ben Smith/
Check Subject Type
Check Subject Type
Check Subject Type

Check Subject Type

For
Gemini_Animal_Lover
From
Reddit
Status
Done
Formulas
test
test
ifs
ifs
! · not
! · not
Share

Work/Personal

ifs(
	!prop("Subject"), "",
	prop("Subject").test("Health|Personal Finances"), "Personal",
	"Work"
)
Old Explanation
if(empty(prop("Subject")), "",
If Subject is empty, display nothing.
if(test(prop("Subject"), "Health|Personal Finances"), "Personal",
Otherwise if Subject contains either Health or Personal Finances, display Personal.
"Work"))
Otherwise display Work.

3+ Categories

ifs(
	!prop("Subject"), "", 
	prop("Subject").test("One|Two|Three"), "Category 1", 
	prop("Subject").test("Four|Five|Six"), "Category 2", 
	prop("Subject").test("Seven|Eight|Nine|Ten"), "Category 3"
)
 
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!