I am attempting to customize the New List Item form for a SharePoint list. There is a column that performs a lookup on another column in a different list. That column has some blank values in it.
My list currently shows a ton of blanks at the top of the drop-down, which is very frustrating. Is there a way to remove the blanks? The current formula used for the drop-down is as follows:
Choices('Work Tracker'.'User Name')
Solved! Go to Solution.
In this case, you can use the following formula:
Filter(Choices('Work Tracker'.'User Name'), !IsBlank(Value))
This will return a table of items that do not have blanks.
I hope this is helpful for you.
In this case, you can use the following formula:
Filter(Choices('Work Tracker'.'User Name'), !IsBlank(Value))
This will return a table of items that do not have blanks.
I hope this is helpful for you.
User | Count |
---|---|
138 | |
135 | |
78 | |
73 | |
69 |
User | Count |
---|---|
223 | |
137 | |
78 | |
60 | |
56 |