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

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?

Page 1 / 1

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

Thanks so much @TheTimeSavingCo!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded