-
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!
-
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