I am trying to add rows to an Excel table. Sometimes one or more of the fields in the row are empty values. I have tried using ifempty(value;“”) but it still throws an error if the value is empty. How do I fix this?
Quotation marks don’t work well within functions. Try using the emptystring pill instead. That should do the trick!
I hope that helps!