-
Converting excel formula to function
I'm having trouble converting the below formula from excel to smartsheets. The biggest issue I'm having is the +1(take from the cell to the right of the Vlookup result) and *-1(make the result value negative). So far I have this but keep getting #No Match How would I go about fixing this? Thank you!
-
How can I sum hours from a single day/class?
Hi, I am using this sheet as a work log, to count the hours a coach has spent with a group of students. For tracking purposes, coaches input 1 form per student, but I need to sum, in the example picture attached, only 1 class of 2 hours for that coach. So if the date and the type of class are the same I should only sum 2…
-
How to count child rows based on assigned to and status
I need a formula that counts child rows (rows that are unchecked in the Parent column), assigned to and status. See screenshot for reference
-
Help with Countif for multiple Criteria
Hi, Formula Novice here. I'm trying to do a calculation for my dashboard to COUNT the number of projects I have in my Column of project status. The criteria I want to count is Developed, In Developed or Not Developed. I only want to count the number of projects that fit this criteria. What would the formula be if I'm using…
-
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(…