I am trying to make the text say Expired or Current compared to a date column OR stay blank if the date column is blank. So far, I have:
"txtContent": "=if([$ExpiryDate]) == '', '' , if([$ExpiryDate] <= @now, 'Expired', if([$ExpiryDate] > @now, 'Current', '')))"
But for whatever reason, the column then shows the ENTIRE formula in the column instead. I have tried several different permutations of the above, including
isblank, but I just can't seem to get the syntax exactly how SharePoint likes it.