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.
Comments
-
Jason,
The formatting (whether conditional or created manually) is not directly exposed to users for programming (either via formula or API).
However, anything that you used as a condition for the conditional format could also be used in a CheckBox column to determine if the condition was satisfied.
Build that and then key the report off that column.
Craig
