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
Hey all, This formula works most of the time, but it won't show the letter grade all the time, I think when its close to an in-between number. Any help making it function 100% of the time and not show an empty cell would be appreciated =IF([Week 04/01 Results]5 > 0.96, "A+", IF(AND([Week 04/01 Results]5 >= 0.93, [Week…
This seemingly simple formula is giving me problems. I want it to count the number of tasks due in the past 7 days through the next 7 days. I am working with the following and getting "#UNPARSEABLE": =COUNTIFS({Owner}, "Joe", {Status}, "In Progress"), {Due}, >= TODAY(-7), {Due}, <= TODAY(+7) I'd appreciate any assistance…
I have columns with construction bids and the rows are the construction activities with cost. I have 2 years of bids and just want to take the average of the last 6 months of bids for each row of construction activity. =IF([1]4:[101]4 > TODAY(-180), AVG([1]@row:[101]@row), 0) Columns are labeled 1 -101 #INVALID OPERATION