-
2 SUMIFS NOT equal to 2 variations
Hello, I've tried the below formula but it doesn't work (instead of SUMIFS A AND SUMIFS B), This works: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple") This doesn't work: =SUMIFS(pay:pay, [Code a]:[Code a], [Code a]@row, [code b]:[code b], "<>apple") + SUMIFS(pay:pay, [Code a]:[Code a],…
-
AverageIF or Avg(Collect) formulas
Hi All, I have multiple criteria and thus used the AVERAGEIF statement, however, this is not working cause this formula only limits to one criteria, and I need to add multiple criteria. For example, we are able to do this with COUNTIFS statement, however, there is not AVERAGEIFS statement. Since AVERAGEIF is not working…
-
Cell Reference to Other Sheet with Column Formula
Hello Smartsheet Community, I have a question regarding cell linking, while maintaining a column formula! I am trying to reference a certain cell in sheet 'X' back to sheet 'Y' and then create a column formula in sheet 'Y' that allows for automation of information that is being captured in sheet 'X'. Is this possible? I…
-
Formula Help - Need to collect number of projects labeled "High" in another sheet
Currently using the PMO template pack and the formula in the portfolio Metrics does not seem to be adding up the categories correctly. Here is the sheet I am working in: the numbers in the High, Medium, Low columns are not accurate. I need them to pull from the main sheet the total number of projects labeled as…
-
SUMIF, IF with OR
Hello, A new comer to Smartsheet. I want to apply the following in a column. IF given date >Today date, then (colA+colB+colc-colD) ELSE given date < Today date, then (colA+colB+colC-colE) Is it possible to do with SUMIF or IF/OR function. Thanks in advance!
-
Cannot get last leg of symbols to work with my formula
Hi guys, I am adding the progress bar symbols into my sheet and I've got most of it working. I just cannot get that last logic check to work. Here's my formula; =IFERROR( IF( AND( NOT( ISBLANK([Order Received]@row) ), ISBLANK([Chair Ship Date]@row), ISBLANK([Chair Install Date Actual]@row) ), "Quarter", IF( AND( NOT(…
-
COUNTIFS AND CHECK BOXES
I tried to go through different scenarios and look to see if this has been asked before but wasn't able to find it. I am count 2 different columns. The first column is a customer's name and the second is a check box. I want to count if there is a customer name (any) in the first column and if that column has a check box to…
-
% Variance between 2 numbers
I am trying to figure out the % variance between 2 numbers ($40,190,187 and $40,279,091) I just need the formula can anyone help?
-
Help with IF and INDEX COLLECT
I need to collect information from two different sheets based on a cell value in another sheet. I have created the formula below, but it doesn't seem to work completely. I get an invalid value error if the employee number is not on the lookup sheets. Thanks! =IF([Airside / Landside]@row = "Airside", INDEX(COLLECT({EqNo},…
-
Formula for Date based off Dropdown
I am looking for help with a formula to calculate a due date based off a drop down. I have 3 options in the dropdown and need to calculate a date based the requested date. <10,000 = quote due in 5 days from requested date . <50,000 quote due in 14 days from requested date <100,000 quote due in 30 days from requested date.