I have a formula =COUNTIF(Age8, >65) which is working, but I want it to only give me a count if a certain checkbox field is checked. Is there a formula for this?
=Countifs(Age:Age, >65, [checkbox column name]:[checkbox column name], 1)
This would count the age over 65 if the checkbox column where there is an age greater than 65 is checked. Checkboxes that are checked have the value of 1, unchecked as the value of 0.
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.