Creating a Report Using Conditional Formatting Workaround

Zack Licursi

Our housing department has a checklist that they will bring to a property to complete with any deficiencies they see in the property, built out in a form. The results are fed into a grid that needs to be reported on. Each column would need to be included in the report if it meets one of the criteria that the conditional formatting is used for.

Since you cannot create a report based on the conditional formatting, what would be the best way to create a report that can include 200+ columns where the fields are included if a condition is met? Would a third-party reporting service be worth investigating?

kowal

hi @Zack Licursi,

unfortunately the reports in Smartsheet are so dynamic to add the columns report based on something.

once you setup the report the columns need to be provided.

Is there a chance that instead of columns you can somehow collect the data in the rows? it would be a game changer for you for capturing data.

Zack Licursi

Thanks for the feedback @kowal. Due to the fact that I am using the rows as the form entries, they will auto-populate based on the feedback that is posted in the rows. Would there be an alternative to capture form entries besides having them populated in a new row? If that was the case, what would you suggest the best option to be for the fields in the form to allow them to populate as rows as opposed to columns?

kowal

hi @Zack Licursi,

I am out of ideas how this can be solved :(