Combining an IF(OR statement with an IF statement


I am using the current formula =IF(OR([Integration]@row = "-", [Integration]@row = "N/A"), "No", "Yes").

Because there is now an option to put in TBD, that needs to be noted as TBD and not just simply "no" or "yes". How can I combine the above formula with one that also says, "If it is TBD, then it should read TBD?

Thanks for your support as always!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!