Using Single Select Column data to make a Multiple...

[Grims]

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? 

[TheTimeSavingCo · Accepted solution]

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]

Thanks so much @TheTimeSavingCo!