Forum Discussion
Sort Function (SortBy) - Trying to get empty cells to return empty cells using the sort function
This is just and aesthetic issue. I have a table with around 7 headings for a simple account information table. Not all accounts have a value for each heading/field so on entering data those cells a...
Hi there,
I believe this can be solved with a simple if statement - I just ran into the same issue and had to solve it.
=if(isblank(Sort(*your sort parameters*)), "", Sort(*your same sort parameters*))
Hopefully that helps you 🙂
I believe this can be solved with a simple if statement - I just ran into the same issue and had to solve it.
=if(isblank(Sort(*your sort parameters*)), "", Sort(*your same sort parameters*))
Hopefully that helps you 🙂
Thank you, this worked perfectly.
