If Function

I'm trying to do an IF function per below but doesn't seem to work. Basically, if it's Amazon or iTunes, it should be "Ordered_Output Platform" and any other category should be "Need to Avail"

=IF(OR(Platform@row = "Amazon PVD Prime Video Direct", Platform@row = "iTunes (Apple TV)", "Ordered_Output Platform", "Need to Avail")

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!