Help

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

Topic Labels: Formulas
Solved
Jump to Solution
689 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!