Please don't tag this as answered the moment you reply, as many of my questions (and I have seen this with many others' questions) that have been labelled "Answered" have not been at all.
I have created a checkbox.
On the Account page the checkbox either shows a tick, or nothing at all.
I have created an inventory template to use the data from the checkbox.
On the template the checkbox returns either false or true.
We need the vale on the inventory template to return a tick or a cross.
Before you tell me "Unfortunately this cannot be done, it will be considered for future updates", I have managed to create a string formula to return a tick or false with the formula below.
Replace('${Invoices.Space Only}','true','✓')
This works perfectly. Similarly this formula below works as well
Replace('${Invoices.Space Only}','false','X')
I need to have both lines in the same formula field.
I am expecting the generic response for this can't be done. So could you please explain why if I put this formula
Replace('${Invoices.Space Only}','true','✓'), Replace('${Invoices.Space Only}','false','X')
The following values are returned
True - ✓,'true
False - false','X
Does someone understand why these values are coming up in the formula field?
Or even better does someone know how I can accomplish replacing true and false with ✓ and X?
- Adam