Need some help from my Smartsheet Community
I have several rows that all have CLINS, I/C/A and BATCH columns. I have created a visual below.
Here is my requirement:
Identify any CLIN that doesn't have a "C" row associated with it. Bottom line is each CLIN and BATCH number requires a C row to be identified. I need to identify any CLIN that doesn't have a C row on my sheet.
So in this example 1334-XXXXX BATCH 3 doesn't have a C row. Any ideas how I can accomplish this?
CLIN I/C/A BATCH
1234-XXXXX C 1
1234-XXXXX C 2
2234-XXXXX C 1
1224-XXXXX C 1
Help Article Resources
Check out the Formula Handbook template!