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