Formulas
Discussion List
- Hi! I need some help getting a formula to work for a sheet summary and have confused myself at this point. I need to get a sum of the reach our national events collected within Q1. Columns: National_l…
- Hello, I would like to sum up costs only for cells that have multiple homegrown fruits within a single month. In this example, January's sum would be $3,500. I've tried a few formulas and thought I go…
- I have a column in my grid that generates the Task number automatically for Level 2 and all of the children below it. IE if I choose the drop down "Task 1" for a row that is level 2 then that row and …
- I need a formula that populates the due date based on the date that its approved. I want the date to be at the end of each quarter
- With so many posts about this why has this feature not been added or fixed? The fact that this is not a feature in Smartsheet makes it extremely difficult and inefficient to accurately determine sched…
- Hello, I am new to Smarsheet and I am trying to figure out the formula that will get me a Monthly Average, Quaterly Average and Yearly Average of Markups that I have for each person on our Team. If so…
- Hi, I have a working formula in my sheet that works beautifully to rollup/count the status within the sheet: =IF(COUNTIF(CHILDREN(), "Complete") = COUNT(CHILDREN()), "Complete", IF(COUNTIF(CHILDREN(),…
- I have a formula I need help with for the top level of my project checklist hierarchy. Overall Project Status - this is looking only at the highest level rows which are indicated by the helper column …
- On my Smartsheet I have multiple sheets. Requests come in on the Request sheet, then move to an Approved, Hold, or Rejected sheet. I'm wondering if some of the column formula's I have should be remove…
- = "Not Started" if NO boxes checked = "In Progress" if SOME boxes are checked = "Complete" if ALL boxes are checked for the attached example I manually changed status based on checked boxes, but I'm h…