I have a column “InfoSichhBelehrung”, which is linked to a table, where users can upload a certificate and a date is stored in the column Belehrungsdatum.
Of course, not each and every user has the needed certificate at the beginning of a year. Some have it, some have an old one from last year or even sooner and some new folks dont have one at all, as they need to go through training yet.
If I check, if a user has a valid certificate for the current year, I get #VALUE! for all user rows, that do not have a corresponding entry in the certificates table
Formula is as follows:
This gives back 1 for this years certificates, 0 for those uploaded earlier and #VALUE! for those users, who do not have one in the linked tables column.
All i want is to supress the #VALUE! and return “” instead.
How can I reach that? isempty() does not work on linked columns, as it seems.
Why do i want to suppres this? Because if I do statistics with those values, I always have that ugly #VALUE! as one group of entries. And since one cannot manually change the descriptive legend names on those graphics generated there… yeah nothing I can send to people.