I have a trouble with creating a condition in the message for alert firing.
I have data:
report name alert ind
I set the alert so that whenever there is ALER in the alert_ind it should fire. And it does, however I would like to have the message "report A needs to be refreshed".
I tried to use ='report ' & if(alert_ind = 'ALERT', [report name]) & 'needs to be refreshed' however this message pops up without A inside..
Can you please help?
Thanks a lot.