Formula Question


I'd like to add a formula to my sheet where if it's blank you do nothing, but if it's not blank, i want to include text and also link to other cells.

Example: If the course number is blank, then do nothing, but if the course number isn't blank then put "Please charge invoice to" [Account Number]@row, "Org Ref" [Class Number]@row, "Class field trip in" [Event Name]@row

Hope that makes sense, i've tried this for 2 days now and i can't figure it out!


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!