Multiple IF not working but if it is separated they are working
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!
My formula is:
IF([Termination Date]@row=0, "Active", IF(TODAY()>[Termination Date]@row,"Inactive","Active"))
Help Article Resources
Check out the Formula Handbook template!