I want to create a cross-sheet formula and have two conditions for the formula to go through to result in a value.
If the value in column1 is 1 and column2 is VendorX then sum all values in column3 corresponding to the conditions.
I am not sure if the SUMIF will work for this.
You should be able to use SUMIFS which checks multiple ranges, like this:
=SUMIFS([Column 3]:[Column 3], [Column 1]:[Column 1], @cell = 1, [Column 2]:[Column 2], @cell = "VendorX")
I'll try this and let you know if it works! Thanks!
It worked!!! Thank you!
Create and edit formulas in Smartsheet
Formula combinations for cross sheet references
Smartsheet functions list
Hi all, I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date. I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working. Any advice would be appreciated! Thank you.
What's wrong with this Formula? Getting an Invalid Ref
I am trying to get a unit count between a date range. I have two difference columns from one sheet and two difference columns on my main sheet I am referencing. I keep getting unparseable. Is there a way to to get the number I want with using the countifs formula? Or should I be using a different formula? This is the…