Bulleted List with if condition

Hi All,
I have a table listing student names as records, and subjects for each column. I want to combine the values for each column to give me a list of completed subjects. At the moment, there is a bullet for each column selected, whether or not there is something listed. How do I create a list that doesn’t put a bullet for a blank cell?

Dear @Andrew_Youd,

What about using the following formulas:


1 Like

Hi @Jean_Pierre_Traets, I tried using the isnotblank formula with the following: bulletedlist(switchif(isnotblank(thisRow.[EDU125 Completed]),thisRow.[EDU125 Completed]),switchif(isnotblank(thisRow.[EDU124 Completed]),thisRow.[EDU124 Completed]))
The output was still:
*

  • EDU124 Completed

What I want is for it to passover the blank cells. any other ideas?

Dear @Andrew_Youd,

:bulb:To see the question in the right context it would be great if you could share a dummy copy of your doc with the community.

1 Like

The purpose of this document is for faculty to track student course completed. I envisage hiding the columns which bring up the subject code: “EDU125 unit”, "EDU124 Unit”. I am aware I could just have a completed column where faculty nominate the subjects, but it is helpful to have the subjects have a column so that they can see their progress across the 32 subjects they need to complete.