Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Create report based on a conditional format in sheet
We are trying to build a report that looks at the format of a cell in the main sheet. We are using the conditional formatting option to set a specific cell's format based on the combination of various other fields in that row. Now that the sheet is correct, we are going to the report builder to create a report that looks for two specific formats that were applied based on the conditional formatting rules. This is where we are not finding the functionality that we were hoping for. Is there something we are missing or a different method for which to have complex filters applied to a report similiar to the the way we can do in the conditional formatting window.