I'm having trouble translating my formulas from a google sheet over to a smartsheet

Im trying to import the above into smartsheet with the formulas in the google sheet but am getting errors.

I'm getting the following error:

#UNPARSEABLE

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!