0

each gallery has few status columns. I want count all status that say "FREE" within each row. Status columns are text boxes.

Using formula below, which does not give any errow, however is not returning desired value.

CountIf(Split(Concatenate(ThisItem.Status,",", ThisItem.Status_2,",", ThisItem.Status_3,","),","), Text="FREE")

any ideas?

List & app snapshot

Improve this question
2
  • Can you show us the data structure (maybe with example values) or screenshot of gallery & example of expected/desired output? It is unclear from the question what exactly you want.
    – Ganesh Sanap - MVP
    Commented Jun 16, 2021 at 15:56
  • @GaneshSanap, I have edit question by adding a list and app snapshot
    – Jose1978
    Commented Jun 16, 2021 at 16:09

1 Answer 1

Reset to default
0

Use the below formula, to count the values based on different columns in a single row.

With({
    status1: If(ThisItem.Status = "Free", 1, 0),
    status2: If(ThisItem.Status_2 = "Free", 1, 0),
    status3: If(ThisItem.Status_3 = "Free", 1, 0)
}, Sum(status1, status2, status3))

I hope, this solves your problem.

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.