{!IF ($User.Full_Name__c='Ciarán Lenehan', URLFOR("https://chanelle.lightning.force.com/lightning/r/Report/00O4G000007tieoUAA/view?(fv0={!Account.Id} & fv5=RFP) "), URLFOR("https://chanelle.lightning.force.com/lightning/r/Report/00O4G000007tieoUAA/view?fv0={!Account.Id}"))}
When the custom link was opened, it should open 'https://chanelle.lightning.force.com/lightning/r/Report/00O4G000007tieoUAA/view?(fv0={!Account.Id} & fv5=RFP)' for user Ciaran, for rest of the users it should be 'https://chanelle.lightning.force.com/lightning/r/Report/00O4G000007tieoUAA/view?fv0={!Account.Id}'.
This isn't working, could anyone tell me where am I doing wrong?
I have tried removing the filter and here is the formula
" {!IF ($User.Full_Name__c='Ciarán Lenehan', URLFOR("https://chanelle.lightning.force.com/lightning/r/Report/00O4G000007tieoUAA/view?(fv0={!Account.Id}"), URLFOR("https://chanelle.lightning.force.com/lightning/r/Report/00O4G000007tieoUAA/view?fv0={!Account.Id}"))} "
It's still showing the same error.