Jump to content

Leaderboard

Popular Content

Showing content with the highest reputation on 06/02/2021 in all areas

  1. Hi @PeterER8, Do you want to count only the number of cells that has 'Green' value per record? Is your expected output similar to the following? If yes, you can just use CASE-WHEN statements in your formula field that will check if the field has 'Green' value. (CASE WHEN [@field:Reason_1] = 'Green' THEN 1 ELSE 0 END) + (CASE WHEN [@field:Reason_2] = 'Green' THEN 1 ELSE 0 END) + (CASE WHEN [@field:Reason_3] = 'Green' THEN 1 ELSE 0 END) + (CASE WHEN [@field:Reason_4] = 'Green' THEN 1 ELSE 0 END)
    1 point
×
×
  • Create New...