Need Help with a formula

04/26/18 Edited 12/09/19

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. 

Popular Tags:


  • 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 WildayMike 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


Sign In or Register to comment.