Jun 11, 2023 09:01 PM - edited Jun 11, 2023 09:03 PM
Hi! I'm new to creating formulas. I can create two IF formulas in independent columns, but am struggling to combine them into a single formula to communicate a task is due in ___ days, but to also make this countdown stop when a task is completed.
This formula is dependent on two fields: Due Date and Status (Not Started, In Progress, Done).
I need this formula to create 3 potential outcomes:
I achieved #1 and #2 with this formula: IF({Due Date}, DATETIME_DIFF({Due Date}, TODAY(),'days') & " days")
I achieved #3 with this formula: IF(Status="Done", "✔️")
But I am not sure how to combine these into one single formula, in one single column.
Solved! Go to Solution.
Jun 11, 2023 10:48 PM
Give this a try:
IF(
Status="Done",
"✔️",
IF(
{Due Date},
DATETIME_DIFF(
{Due Date},
TODAY(),
'days'
) &
" days"
)
)
Jun 11, 2023 10:48 PM
Give this a try:
IF(
Status="Done",
"✔️",
IF(
{Due Date},
DATETIME_DIFF(
{Due Date},
TODAY(),
'days'
) &
" days"
)
)
Jun 11, 2023 10:53 PM
Perfect, thank you!