Need Help with a formula

edited 12/09/19 in Formulas and Functions

I'm trying to convert an excel spreadsheet to a smartsheet.  How would I convert this formula?  =IF(SUM(AH6:AL6)=0,,AJ6+$AP6+$AS6+$AT6)


Yeah, I am an extreme rookie when it comes to this stuff. 


  • If you import the file, there is a box you can check to include formulas.  It would seem that it should then be imported.

  • Mike Wilday
    Mike Wilday ✭✭✭✭✭✭

    If you want to rewrite it yourself, you need to be aware that Smartsheets references the column names.

    Just substitute ColumnTitle3 for A3 - and so forth and so on. 

    But if your column names contain spaces or end in a number you would surround that name in brackets.

    Column A - Row 3 would be [Column A Title]3


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!