I'm trying my first fx columns in a model driven app. The first columns worked fine now I try an if statement with date only fields. I wan to check if a field is blank to decide which value to show in the field. I am sure that the = blank() is wrong but what would be the correct statement to check if a field is empty?
I found the cause for the error. It was in the field Extend warranty which is using the product warranty in it's formula and that causes the exception.
Hi Lauren,
thank you for the quick reply. I tried that way also but it always gives me an error. I get the slight feeling that there is something in the environment that is not correct. Just for the record I get the error only when using the blank or IsBlank in a different field I have a if statement and that works.
The error is one of the brilliant kind: "Something went wrong. Please try again later."
You can use The IsBlank function which tests for a blank value or an empty string.
If( IsBlank( 'Extended Warranty' ), 'Product Warranty Expiry', 'Extended Warranty')
Please thumbs up if it helped or mark as solution if it worked for you 🙂
stampcoin
17
mmbr1606
15
Super User 2025 Season 1
ankit_singhal
11
Super User 2025 Season 1