To count the number of unchecked boxes I'm using the formula: =COUNTIF([% Complete]3:[% Complete]60, 0). The issue is that it is also counting blank rows. How do I get it to only count actual blank checkboxes?
My personal workaround was to create another checkbox column called "Header" and check that box if a row is header type row or maybe a divider. Then I hide that column.
Then using COUNTIFS to look at the header column and the % column
=COUNTIFS([% Complete]3:[% Complete]60, 0, Header3:Header60,0)
Maybe there is an easier way but that's the way I've been doing it.
Hello, Can a combination of the INDEX(COLLECT and NETDAYS Formula be used to get the number of days between two dates in the same column? I want to get the number of days between two dates on the same sheet, in the same column, that have matching names and different project types. For Example: Studio Name is equal to…
I am trying to pull a phone number and email from our master roster that is on another sheet in Smartsheet. I cannot figure out the formula. This is the formula I have tried. =INDEX([EMPLOYEE NAME]@row , MATCH({IMS Master Roster Range 2}), 0)
Hi All, I keep getting this annoying error when I try to trigger a PDF generation. I initially set up to trigger the PDF generation to kick off once the last field the needs data is "not blank". That is when the error started. I modified the sheet and added a yes/no drop down to trigger the PDF generation when the value in…
