Report to show Unchecked Columns

I have a sheet that has about 12 columns with checkboxes is there a way to create a report that will show every column that has unchecked boxes by row, which is the date?

To explain further I have a report that has all the columns with names and the check boxes. I'd also like a report that only shows the columns that are not checked for each day (row).

Does that make sense?

Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    The formula is going to depend on the layout of your sheet. You can either use a string of IF statements to say that if the box for [Column Name]@row is not checked, then output "Column Name", or my personal recommendation would be to use a helper row where you enter the column name into that row (for this example I will refer to row 1, but you can use whichever row you want). then you can use a JOIN/COLLECT that looks something like this:

    =JOIN(COLLECT([First Checkbox]$1:[Last Checkbox]$1, [First Checkbox]@row:[Last Checkbox]@row, @cell <> 1), CHAR(10))


    The CHAR(10) as the delimiter is a line break so each task is on its own line within the same cell for that row.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!