I have 10 number fields in an item: Book 1, Book 2, Book 3 and so on up to 10.
In a calculation field I would like to show a list of all the books that have number next to them, leaving out the books that don't have a number in its field, looking like this:
Book 1: 5
Book 2: 3
Book 8: 6
Book 9: 8
Book 10: 2
In the above, books 3, 4, 5, 6 and 7 in the podio item would be black, so not shown in the list.
I have played with a variety of IF statements but it's quickly gone beyond my brain. Any help would be amazing!
Please sign in to leave a comment.