Need Help with a formula

leahr46246
leahr46246 ✭✭
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. 

Tags:
· Share on FacebookShare on Twitter

Comments

  • Joy Durham
    Joy Durham ✭✭

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

    · Share on FacebookShare on Twitter
  • Mike Wilday
    Mike Wilday Community Champion

    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

     

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!