-
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!
-
If, Then Formula Needed
I want a formula to check if an @row cell is blank. The cell referred to is circled in red. If it is NOT blank, I want a default value populated in the cell with the formula (circled in green):
-
Is there a way to use a formula to tell my contact cell to populate based on another field?
So, I have my team member names populating in the sheet with just their initials - but I want to be able to tell the sheet that if those initials are in the "team" field, then add this matching contact to the "Assigned to" field. Is there a way to do this? I can drag the names down, but just was hoping for an automation
-
SUMIF Criteria met
I'm trying to calculate the sum of the numbers in a cell when the cell meets a criteria range. This formula works fine for providing the number in cell that is greater than 30. But what if I want the sum to be the total of the numbers in the cells that are equal to or greater than 25 and less than 30?…