Solved

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

Forum|Forum|1 year ago
March 17, 2024
2 replies
29 views

+3

Grims
New Participant

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?

Best answer by TheTimeSavingCo

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"
		)
	)
)

+31

TheTimeSavingCo
Brainy
Answer
Forum|Forum|1 year ago
March 17, 2024

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"
		)
	)
)

Adam, Airtable Consultant - thetimesaving.company

G