Multiple IF not working but if it is separated they are working

Condition 1

If Termination Date field empty = Active;

If Termination Date is before TODAY = Inactive

I tried the below in excel, it was working then it is not working in Smartsheet when lump together but separating the formula, it works!

Please help!

My formula is:

IF([Termination Date]@row=0, "Active", IF(TODAY()>[Termination Date]@row,"Inactive","Active"))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!