I want to count number of true or false status in switch columns and number of blank row in that column.
Tried several option with roll up, it gives total count of true and false without considering blank row. My requirement is to know how many true and how many blank row.
Can you show a screenshot of what you are trying to do? I think you can do this if you create another If Then column that looks at the switch as well as blank and sets the result to True. Then you can do the rollup against the new If Then column. I’m not sure though if I understand what you want. What do you mean by a blank row? Is it completely blank, or just only some columns are empty? Do you want a count of True, False, and Blank or do you want a count of just True and Blank?
@Jeff_Hager Earlier it was not working tried all your mentioned way and then applied formula in sheet to achieve that. Today once again tried after your msg and worked absolutely fine. Now deleted additional formula from spreadsheet. Surprisingly seeing no blank data in switch columns, it is either true or false. Thank you for your suggestion.
Can you please tell me how to make switch data true by default, it is to be used facility management complain tracker, whenever user log a complain by default it should be true and when issue is closed user will have option to switch off, so that it will be recorded as complaint resolved. Presently all check box is by default false.
Here is a response I posted in a different thread:
In whatever sheet contains the form button, create a template column and fill the value with ‘true’. In the form, pass that value as a Column value directly to the sheet into your switch column. Later when viewing the complaint, display the switch column as a switch that can then be turned off.
Personally it makes more sense to me to keep the value as false and the set it to true once it’s resolved, but that is only my opinion. I’m sure you have your reasons for making it default to True.