-
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…
-
COUNTIF example formulas using check box columns
Would anyone have a example of a formula to count checked boxes in a column divided by the number of unchecked boxes. Any help will be greatly appreciated. Thanks.
-
Formulas: Reference Data from Other Sheets
Good afternoon Smartsheet Community: I am trying to add the total from the count of 2 sheets given the criteria. However, I am receiving an INCORRECT ARGUMENT SET when using SUM or Count conditions (formula below). Any help appreciated, Thanks! =SUMIFS({A9: PayChex TLS Impact List Range 1}, "Need A File Build", {A2: ALL…
-
sum with new vlookup sheet reference
I have this formula copied down a column: =vlookup(A1,ReferenceAnotherSheet,3). The first row bring back the correct number value. The other rows are bringing back a #nomatch. Also, I want the cell to return the total of all cells in column 3 that contain the cell referenced in A1. I know I need to use sum or sumif, but…
