Formula Help to bring data from two cells into one

Ruth Schoonover
Ruth Schoonover ✭✭✭
edited 04/05/24 in Formulas and Functions

I am trying to pull data from two cells into one. I think I almost have it but I keep getting an unparseable error.

=IF([Person Responsible]@row <>, ""[Person Responsible]@row"", IF([Course Facilitator]@row <> "", [Course Facilitator]@row, ""))

Thanks for the help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!