I use the following function to count "=COUNTIF({Cell Range 2}, 0)" numerical values from a column. However, I should only count the cell values when a cell value in the same respective row but in another column is blank. Not sure how to proceed.
Hi,
Is this what you're looking for?
https://community.smartsheet.com/discussion/it-possible-count-blank-cell-only-text-filled-out-another-cell
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
It sounds like you might want to use a COUNTIFS statement where you can indicate more than one condition.
=COUNTIFS({Cell Range 2}, 0, [[[Create your other cross reference cell range here]]], ISBLANK(@cell))
You might also try the following formula cause off the top of my head I can't remember whether its cell or row,
=COUNTIFS({Cell Range 2}, 0, [[[Create your other cross reference cell range here]]], ISBLANK(@row))
Hello, Just investigating an idea. I'm building a staff register sheet. I'm curious to know if its possible to populate specific cells by the answers given in a form? So if, in a form, a staff member gives their name, the date and that they will be on leave, sick, training ect. Once the form is submitted, it will populate…
My current formula is below. I would like to update this so that I only get a total of those that have been Quoted and have a timeframe data of 2025. How do I add this extra filter into the formula? =SUMIF(Status:Status, "Quoted", [Est. GP]:[Est. GP])
I'm not able to "view by" a field that I have in my sheets - Quarters (Q1, Q2, Q3, Q4) - in my report. I think it is because I have used a formula to calculate the quarters in my sheets. Does anyone know a way to get a formula based field on the dropdown for view by in my report?