Exception output

Hi

I have a data which has 312 line item to validate, with the help of “filter tool”309 are valid exceptions and 3 three are actual exception on which I have to work. In the output file I need these 3 line item tagged as “Research” and 309 as “Valid exceptions”.

Workflow

Accepted answers

This formula should work for you, I have attached an example for you.

Screenshot 2023-08-07 133919.png

formulasol.yxmd

All comments

Use a formula instead of a filter. In the formula tool Use an IF statement with the criteria used in your filter tool. If those 3 records match the criteria set the THEN statement to "Research", ELSE "Valid Exceptions".

IF [FIELD BEING TESTED] = (Criteria for 3 fields to be triggered) THEN 'Research' ELSE 'Valid Exceptions' ENDIF

This formula should work for you, I have attached an example for you.

Screenshot 2023-08-07 133919.png

formulasol.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15878

MarqueeCrew 13708

apathetichell 13703