IN PICTURE (A)- i have successful JOIN COLLECT formula
IN PICTURE (B)- I tried to replicate the formula, but add additional columns I needed to be joined as well.
IN PICTURE (B-1) Incorrrect Argument
The COLLECT function has the syntax of COLLECT(Range where the data is you are trying to collect), Range1, CRITERIA1, Range2, CRITERIA2, etc). The data is always added to the COLLECT function in a range-criteria pair. The formula B above does not list criteria for any of the ranges.
In Formula A, it says to collect Cost Center data when the Cost Center rows have data on the same row in the [Invoice No] column that matches the current row Unique Invoice .
If you describe the data you are trying to collect, the community can help you with the specific formula.
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
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…
This might be a silly question but I'm stuck...a little rusty! I am trying to do a count formula for a dashboard that has a summary of how many sites are activated using this column whenever it's starred. The formula will be on a separate sheet used for dashboard metrics. Is it =COUNTIF(Sheet reference), HAS(@cell)) I know…
©2024. All Rights Reserved Smartsheet Inc.