Getting #UNPARSEABLE error

Hi all,

I've four colums A, B, C, D. Objective is to A*B + C*D = total number.

I'm getting an error. Not sure why? Highly appreciate if anyone can help. Attached is the error!



Best Answer


  • Dale Murphy
    Dale Murphy ✭✭✭✭✭✭
    Answer ✓

    @SIS I think if you get rid of the square brackets after two of the @row expressions you should be good.


  • SIS
    SIS ✭✭

    Thanks, Dale. Another question I was trying to generate a report from this datasheet quarterly. Currently I just enter details month by month and count the total # test manually.

    The goal is to make this automated in a way that the dashboard is going to divide it by quarter and capture only the total # of tests done.

    I'm new to Smartsheet! Still navigating! Given that this list will be updated continuously.

    Will highly appreciate it if you can suggest me something. =)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!