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
=IF({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "3. Moving Along", "Green", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "2. Needs Monitoring", "Orange", "" ({VPAL Portfolio Status Range 2} = "CoaP" + {VPAL Portfolio Status Range 1} = "1. Needs…
I've read multiple posts and articles but something just isn't work in my SUMIFS formula. I'm trying to add the number in the Social Posts ({SPosts}) column if the Type ({Type}) is "Social" and the Team ({Team}) matches the name in my summary sheet column (Label@row). Any help would be greatly appreciated.
So I am trying to make a metric sheet that uses a COUNTIFS sorting by month, year, lane, and to only count if approve is check. I will make a dashboard that eventually sorts by the lanes (3 of them in total) and it will be tracked for trends in change in months and years. Below is the sheet that is connected to a form…