How can i use countif when in condition i want compare another column

[Piter_D]

Hi, I have a question, can I use CountIf, if I want to check if there is a value specified for this record in another column?

For example:

 CountIf(Shortages.Item, 'Production Line'.Text = "A")

Production Line is a column like Item in Table named Shortages

[JR-BejeweledOne]

It's going to depend on where you are trying to put this formula.   Is this a selected item in a gallery?

[ShockWave]

In text label

[JR-BejeweledOne]

You indicated that this is for the current record.  How are you telling the text label that you have a record selected?   Is the label in a gallery or table for the current record?

[Piter_D]

In the gallery

[gabibalaban · Accepted solution]

@Piter_D ,

Yes ... The formula is quite good, but is a little bit slow for large data sources, as Countif() function iterate through entire data sources checking the formula.

 CountIf(Shortages, 'Production Line'.Text = "A")>0

For better results, use:

 IsBlank(LookUp(Shortages, 'Production Line' = "A"))

The result will be true if there is no record in Shortages table with condition fulfilled.

Hope it helps !

[JR-BejeweledOne]

To build on what @gabibalaban said, if you just need to see if the production line column for the selected record is blank.

IsBlank(ThisItem.'Production Line')