Column rules and conditions with if/then scenarios

[Iulia_Stoi]

Is there a way to create if/then scenarios to set a condition for a column?

I have a project clean up report where I need project owners to emphasize form fields that they need to complete as part of their project planning. I would like to create a condition where IF a selection is made in one field, and not an a subfield, THEN the report will highlight the missing entry for the subfield. 

For example: our project entry form requires the selection of the market and business line of that market. In this case if the project owner selected a market but did not complete the business line for that market, the report should highlight that field in a color to emphasize this is a missing entry for their project. 

How can I achieve this using reporting column conditional rules?

[Sven-iX]

Hi @Iulia_Stoi

I don't fully understand: You have a PROJ form with 2 custom fields, market and business line. 
You write you want a highlight in case 

• market is selected
• business line is not selected

Does that mean you do NOT want a highlight when 

• market is not selected and business line is not selected
• only business line is selected

?

If so - you'd need a 3rd field (calculated) that does this check, so you can use that calculated field's value in the styling condition. 

The styling logic is pretty limited: it looks at a single field and compares its value with a either a given value or with another field - but you cannot do logic like "if field A is not blank and field B is blank"