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!
@SIS I think if you get rid of the square brackets after two of the @row expressions you should be good.
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. =)
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi, I am wanting to display multiple vlookup results from a separate sheet into 1 cell. Example: Cabling Allocation Sheet, where we input an allocation to a text name "ECC" which can be multiple cables in the same run. Requirements Sheet - Need the output to be "115, 116, 117" (I have manually written them in at the…
Hi everyone, I have one of those pesky formulas that is giving me a hard time. This is for a Summary Sheet I'll use to build a dashboard so I'm referencing another sheet with the data. Here's what I am trying to pull...Count if the following is true: 1) Project name is the same as the project in the summary sheet 2) Month…
I am trying to calculate two fields in SmartSheet (a dollar amount by a tax percentage in decimal format). I then would like to divide the calculation in half. For example, I would like my hotel rate $109 times the tax rate of 12% to be multiplied together to get the total hotel rate and then divide that total rate in…
©2024. All Rights Reserved Smartsheet Inc.