Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Show "Late" tasks in Deadline Alert column as "Done" when "Done" selected in Status column?

Topic Labels: Formulas
Solved
Jump to Solution
563 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Grims
4 - Data Explorer
4 - Data Explorer
I'm using this formula in a Deadline Alert column:
 
IF({Deadline} < NOW(), "Late", IF(IS_SAME({Deadline}, TODAY(), 'day'), "At Risk", "On Time"))
 
I have a separate Status Column to mark tasks Done. Is there a formula to show "Done" (instead of "Late") in the Deadline Alert column when "Done" is selected in Status? 
1 Solution

Accepted Solutions
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think if you put that IF in front of your existing ones it'd work fine:

IF(
	{Status} = "Done", 
	"Done",
	IF(
		{Deadline} < NOW(), 
		"Late", 
		IF(
			IS_SAME(
				{Deadline}, 
				TODAY(), 
				'day'
			), 
			"At Risk", 
			"On Time"
		)
	)
)

See Solution in Thread

2 Replies 2
TheTimeSavingCo
18 - Pluto
18 - Pluto

I think if you put that IF in front of your existing ones it'd work fine:

IF(
	{Status} = "Done", 
	"Done",
	IF(
		{Deadline} < NOW(), 
		"Late", 
		IF(
			IS_SAME(
				{Deadline}, 
				TODAY(), 
				'day'
			), 
			"At Risk", 
			"On Time"
		)
	)
)
Grims
4 - Data Explorer
4 - Data Explorer

Thanks so much @TheTimeSavingCo!