-
Sum children if a condition is met in another column
Hi, Im trying to count the children of column [Estimado Importe Total] but I just want to count the values if the condition in column [Estatus Factura] says "Pagada", if not I just want to skip that row and count the rest of the conditions that are met. Here is my example: Hope someone can help me. Thankyou!
-
Adding only numbers in a column that contain certain text in another column
I need to add only the numbers in the SUBTOTAL VACANT USEABLE AREA column where the SUITE NAME column has the text "VACANT". Some of the suite names have text in addition to "VACANT" . These numbers need to be included in the sum as well, but I've not been able to make this happen- the formula I'm using will only include…
-
Should I use IF or IF(AND....or Something Else?
Good afternoon everyone. I was hoping someone could help me with a formula I'm having an issue with I tried a few different equations. I found by removing one of the parts of the equation, I received a Yes response, however, when I tried adding in the other part, I received an error of either "Incorrect Argument Set" or…
-
IF function and returning a blank cell
Hi! I've tried several different versions of this function and haven't had any luck so far getting it to work. I want the function to return Yes, No, or stay blank as a way to indicate whether tasks were completed on time. Yes means the task was completed on time, No means the task was late, and blank means the task hasn't…
-
I am looking for a formula to return the information in a cell based on date of the entry.
I am tracking safety incidents, none incidents, observations and near misses. I want to be able to transfer the information that was entered yesterday to the cell in the upper right hand corner. The same is true for the information entered today. i will then display this information on a dashboard.
-
IF / CONTAINS using a range
Have an issue I thought I had resolved, but ... I have a sheet that has two relevant data ranges: Range 1 = a single column that specifies a Content Type for each row item. There are 7 possible Content Types: Data Sheet, Ordering Guide, BDM, TDM, Demo, Learning Map, Proposal Range 2 = 15 columns that contain a Product…
-
Adding a value to a cell with pre-existing value based on another checkbox cell
I am trying to add a value to a cell if a checkbox is checked. The cell I am trying to add to is already populated with an existing value. I want to add the two for a new value. If Lift check box is checked then add $467.50 to revenue cell(already populated with $1800, for a total of $2267.50 Trying with this, but no luck…
-
formula to calculate the week prior to a specific date (refer
Example: Look back 7 days from 5/3/2020. =DATE(2020,05,03)(-7) I’ve tried a few things and can’t get it to work. Any ideas? =COUNTIFS({Layoff - MASTER Range 2}, >=TODAY(-30), {Layoff - MASTER Range 1}, "Layoff") It could be that my column headers are dates and I don't have a date category/row to pull from. Any ideas?
-
Mirroring a Grandchild row cell in the Child row cell based off current week
Hey all, I'm relatively new to Smartsheets and am hoping someone can help me out. I promise I've looked everywhere for an answer and I think I'm making this more complicated than it is. Thanks in advance for the guidance! I have a sheet where I'm tracking historical quote metrics by Sales rep and Week. At the suggestion of…
-
Summary Report - COUNTIF of multi-selection columns
I love the way a Summary Report can kinda be a poor man's pivot table within Smartsheet, and it works really well, up until you try to do conditional counts of columns with multiple selections. See below. What's happening here is I want to allow a COUNTIFS when a person is chosen, and count the number of instances data…