now(), "🟢", "❔" ) ) ) ) ) ) ) ) ) ) // Indented for legibility. You have to use the single-line version (above) for Notion to make it work. if(prop("Pitch Status") == "Accepted", "🎤", if(prop("Pitch Status") == "Submitted", "📝", if(prop("Pitch Status") == "Rejected", "👎", if(prop("Pitch Status") == "Declined", "🙅♂️", if(prop("Pitch Status") == "They Never Responded", "👻", if(prop("Pitch Status") == "Didn't Apply", "🟤", if(prop("Pitch Status") == "Inv"> now(), "🟢", "❔" ) ) ) ) ) ) ) ) ) ) // Indented for legibility. You have to use the single-line version (above) for Notion to make it work. if(prop("Pitch Status") == "Accepted", "🎤", if(prop("Pitch Status") == "Submitted", "📝", if(prop("Pitch Status") == "Rejected", "👎", if(prop("Pitch Status") == "Declined", "🙅♂️", if(prop("Pitch Status") == "They Never Responded", "👻", if(prop("Pitch Status") == "Didn't Apply", "🟤", if(prop("Pitch Status") == "Inv"> now(), "🟢", "❔" ) ) ) ) ) ) ) ) ) ) // Indented for legibility. You have to use the single-line version (above) for Notion to make it work. if(prop("Pitch Status") == "Accepted", "🎤", if(prop("Pitch Status") == "Submitted", "📝", if(prop("Pitch Status") == "Rejected", "👎", if(prop("Pitch Status") == "Declined", "🙅♂️", if(prop("Pitch Status") == "They Never Responded", "👻", if(prop("Pitch Status") == "Didn't Apply", "🟤", if(prop("Pitch Status") == "Inv">
// This is the formula I'm using for "Status".
if(prop("Pitch Status") == "Accepted", "🎤", if(prop("Pitch Status") == "Submitted", "📝", if(prop("Pitch Status") == "Rejected", "👎", if(prop("Pitch Status") == "Declined", "🙅♂️", if(prop("Pitch Status") == "They Never Responded", "👻", if(prop("Pitch Status") == "Didn't Apply", "🟤", if(prop("Pitch Status") == "Invited", "💌", if(prop("CFP Closes") < now(), "🔴", if(prop("CFP Closes") == now(), "🟡", if(prop("CFP Closes") > now(), "🟢", "❔" ) ) ) ) ) ) ) ) ) )
// Indented for legibility. You have to use the single-line version (above) for Notion to make it work.
if(prop("Pitch Status") == "Accepted", "🎤",
if(prop("Pitch Status") == "Submitted", "📝",
if(prop("Pitch Status") == "Rejected", "👎",
if(prop("Pitch Status") == "Declined", "🙅♂️",
if(prop("Pitch Status") == "They Never Responded", "👻",
if(prop("Pitch Status") == "Didn't Apply", "🟤",
if(prop("Pitch Status") == "Invited", "💌",
if(prop("CFP Closes") < now(), "🔴",
if(prop("CFP Closes") == now(), "🟡",
if(prop("CFP Closes") > now(), "🟢",
"❔"
)
)
)
)
)
)
)
)
)
)