-
COUNTIFS on the same column and COUNTIFS on other columns
Hi I am trying perform the COUNTIFS function and can't get this to work. So what I need to count is the following * Count if criteria is "s" in the function column * Count if criteria is "Med" in the priority column * Count if criteria is "No" in the project column * And from the same project column I need to count if…
-
FORMULA - Trying to set a Status based on Date and %Complete
I'm trying to set the RYG status of a task based on End Date and % Complete of the task. I've put a formula in place using =IF(AND(... but I keep getting the error "# INCOMPLETE ARGUMENT SET" Below is the formula, can anyone tell me what I'm doing wrong or missing, please.... =IF(AND([End Date]19 > TODAY(+10), [%…
-
Minus workdays from dates
Hello, I'm trying to minus days from dates using the following formulas but am getting errors everytime: =NETWORKDAY([Date Printed]8 - [Date Dispatched]8) - gives me the error #Incorrect Argument Set =NETWORKDAY([Date Printed]8, [Date Dispatched]8) - gives me #Invalid Data Type What i'm trying to do is find out how many…
-
Formula - adding two columns based on a condition
I think I'm close but this is driving me crazy. I have an event code column and two other columns where I am collecting participation data on Saturday and Sunday. I would like to know the total participation for the weekend. The formula for just Saturday or just Sunday works =SUMIF([Event Code]:[Event Code], "CL021718A",…
-
Named ranges in a formula not "actively" importing from cells expire.
I folks. I think I found an edge-case in your new cross-sheet formula system. I wrote some index formulae to pull related data from other sheets when the user chose some options from a list. All was working, and I was able to link, customize and test the named ranges. I got my two sheets converted to the new system and was…
-
Formulas to link cells
With the recent expansion of formulas to cross reference other sheets I would love to be able to split projects to other sheets. If I could pull the Primary column and the Start Date column via formula I could have secondary sheets that have their own unique information. The new help sheet here, Referencing Data from Other…
-
Sumif for an month to day invoice amount with date criteria
I have an Invoice Smartsheet which has invoice amount for invoices for last several months. I have to calculate month to day invoice amount. I have given the following formula: SUMIF([Inv Amt Rs]:[Inv Amt Rs], [Inv Date]:[Inv Date] > "02/01/2018") This evaluates to zero, even though invoice amount is there in the range.…
-
Simple Subtraction Question - Cell Contains Formula
I have a hard keyed number in a cell (113), in cell to right is a formula =COUNTIF(Status3:Status97, OR(@cell = "Active", @cell = "Invited")), resulting in a count of 93. I am trying to subtract the 113 from 93, with result of 10 displayed. I know this is simple but I can't figure it out!
-
Do Cross-Sheet References Impact Sheet Load Time?
As my Smartsheet app has gotten more complex I often try to find ways to simplify sheets and speed things up. The new cross-sheet reference capability has me wondering if it would be faster than the existing links when loading a sheet? I don't know exactly what goes on when you load a sheet but the save icon stays dark…
-
Formula creates a String - Cell no longer blank/empty conditional formating
Hello, I have a particular problem, I have a series of cells that have formulas to detect the checked values of a series of Check Boxes, creating conditional formatting and inserting 'N/A' in certain cells: =IF([Assemblage Mecanique]8 = 1, "N/A", IF(Coupe8 = 1, "N/A", "")) after this check the cell retains a sting of…