Need Help with a formula

leahr46246 · 04/26/18

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.

Joy Durham · 04/26/18

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 · 04/26/18

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

Comments