-
Sum of Children - not working
Hello All, I'm trying to get the sum of children. There are 4 children rows, with multiple rows beneath that. See image. In this case, the top row with cell value 0 would have a 2 because it's summing the purple 0 and purple 2. Purple 0 and Purple 2 are counting the cells below (children) that have checkboxes. I'm using…
-
Using CHILDREN(cell address) as a range in SUMIFS
I am trying to find the total of Task Total Hours only for rows with a tier level of 2 and where % complete = 1. I am writing this in a summary cell in a mini-dashboard that requires me to write the formula in the % Complete column. I am trying to use CHILDREN(cell address) as a range. What I have read leads me to believe…
-
Sum of quantities on a given date
I have a date column for installs. I also have a column where we enter a quantity. I am trying measure installs on each day of the month. We want to be able to look at a particular date and see how many installs we have on this date. We have about 120 properties Im thinking a roll up sheet with each of the properties on a…
-
Formula to change text
Hello, How do you generate a formula to change the text within a cell. I want to have different text for different due dates such as if the due date is within 5 days, I want the "status" cell to say immediate, and if it is within 2 months, I want the status cell to say "short term", if it is within 4 months, I want the…
-
CountIf and Exclude Status
Hello! I am trying to count the number of requests types and exclude certain statuses. The current formula is: =COUNTIF({Request Tracker Range 4 - Request Type}, Category13). I want to display the current number of Client or Internal requests and omit Completed or Declined. Any suggestions are appreciated!
-
Formula that averages a column
HI Smartsheet community, I need a formula that averages one column (# of jobs) if a checkbox is checked. I think I need to use AVERAGEIF and ISBOOLEAN, but I can't get the syntax right. Help! -Bridget Sloane
-
How do I create a cross-sheet formula for a sum $ total within a date range
I'm trying to calculate the total spend for a customer based on a list of transactions in another sheet in a specific date range. The dates in the sheet I'm trying to reference are classified as dates in the column properties and appear as "1/30/19" for January 30, 2019. For example, in the sheet in which I'm attempting to…
-
Using Approvals with a formula cell
I am trying to use an approval request to change the value of a cell that contains a formula. The cell that has the formula is based on data in two other cells. For example, the other two cells can either be "Yes" or "N/A". If both of them are "N/A", then my approval cell automatically changes to "Yes" and it does not…
-
#Incorrect Argument??
I'm trying to build an IF statement that will change the value in a Status column. The Status column has three values in the dropdown (Not Started, In Progress, Complete). I would like to leverage two adjacent Date columns (Scan Started, Scan Completed) to auto-change the values in the Status column, but can't seem to get…
-
Adding Checkboxes
I am trying to created check point progress with check boxes and a visual aid. I created a If formula, but my progress is not adding up. I would like to know if anyone can help me with a better formula.