-
COUNTIFS #INVALID REF appear after a period of time
Hello, Able to get the countifs to total up some information in a different sheet. But then after a period of time, some of the cells using the countifs display #INVALID REF when it worked when I created my sheet screen shot shows a portion of my sheet, all cells use countifs and all cells did count what I wanted it too.…
-
Formula that returns true/false if today's date falls between two dates on my sheet?
I am trying to write a formula that returns true/false when today's date falls between a date range on my sheet. I want the formula to return "true" if today's date falls between "Start Date" and "End Date." Below is my current formula, but I continue get a returned value of "#DATE EXPECTED." =IF(AND(TODAY() >= [Start…
-
Formula to count how many people will be in the office specific day(s)
I have 2 sheets and I'm trying to populate how many people will be in the office on specific days. One sheet has the specific date(s) and where the sum value should be and i need to gather from another sheet who is coming in on the specific days. I tried formulas but kept getting an error.
-
How can I fix the range of my Average formula within a row?
Hi there! Normally, I am using formulas to summary something like countifs, sum,average by column and it is very easyto have a fixed column range. Now, It's my first time to have a horizontally tabulated data and I want to get the average TAT within a row and make a fix range so that It will get the new columns being…
-
Use a checkbox to toggle a formula that = the cell above.
I'm wanting to use a formula to populate a cell with the information in the cell above if the checkbox is selected. =IF([Request Sign Off]5 = "1", =Address4, " ") in this formula, Requested sign off is a checkbox, and Address 4 is the cell above.
-
Nesting IF ISBLANK Formulas
I have two columns with three possible outcomes I can get these three formulas to work independently but not sure how to string them together. =IF((ISBLANK(CEO1)), "CEO") =IF((ISBLANK(CFO1)), "CFO") =IF(AND((ISBLANK(CEO4)), ISBLANK(CFO4)), "BOTH")
-
rounding up to a specific number
Does anyone know if it is possible to round up to a specific number? I would like to round up a column of numbers to the nearest 9.95. i.e 1256.18 would round up to 1259.95, 862.68 would round up to 869.95 etc. I'm really hoping somebody can help.
-
Ranking within hierarchy (=RANKIF)... using CHILDREN/PARENT/ANCESTOR instead of COUNTIFS
Hi! I want to create a ranking within a hierarchy, here is a attached a simplified example of what I'm trying to achieve (my real sheet is 200+ lines and has a 5-level hierarchy). Right now I'm using this formula (in column Rank hierarchy 1) =IF(Hierarchy@row = 1;COUNTIFS(Hierarchy:Hierarchy; $Hierarchy@row; Value:Value;…
-
Summing a summary sheet report
Hi all, I have built a sheet summary report, and this is showing the data that I would expect. I would like to be able to sum each column - (i.e. one of the columns is no of reports that are live) so that I can get a total, and to put this on a Dashboard either as a Metric or have 5 or 6 columns combined in a chart. Sorry…
-
How to calculate values in a row?
Hi, I am just new in smartsheet, how can I calculate values in a row ? Please help. Thank You!