Need to know if a formula is possible in Smartsheet

I have a formula from Excel that I can't get to work in Smartsheet, so I need to know if it is possible or not.


The first part, SUM, is looking to see if Column B is Shift 1, then sum Column E Plan DT. Second part, COUNTIFS, is again looking for Shift 1 in Column B but is now counting the blanks in Column C the Item No and then multiplying that by 480. Both results added together to get a total I need.

I can sort of get it to work in Smartsheet. The formula as is I get a number way too big, if I remove the *480 then my result is about half what it should be.

Here is the formula working in Excel.

Any help will be much appreciated.

Thank you!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!