Getting #UNPARSEABLE error

SIS

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!

Thanks.

Error.PNG

Dale Murphy

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

dm

Dale Murphy

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

dm

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. =)