Multi-Substitute formula

Hi everyone,

It could be very nice to have a new formula to allow replacing several values by others instead of only one with the substitute function.

For example, to replace "," by "." and " " by "", the current way is :

SUBSTITUTE(SUBSTITUTE([Text], ",", "."), " ", ".")

The new way could be :

SUBSTITUTES([Text], ",", ".", " ", "")

Have a nice day !

Tom

Comments

I agree that this would be nice…

Ability to leave notes on Users within Administration
In as much detail as possible, describe the problem or experience related to your idea. Please provide the context of what you were trying to do and include specific examples or workarounds: I would like the ability to add "notes" to a users profile within Anaplan. This would allow cross-admin management of the…
Anaplan XL for Google Sheets
Hi team, Our company relies heavily on Anaplan XL for some of our reporting needs. We are transitioning from MS Office to Google Apps and we do not have a viable path to seamless transition if there is no version of Anaplan XL for Google Sheets. Please consider launching Google Apps addons with similar functionlaity as…
Keep row sub totals/totals when filtering a List/text formatted column in a combined grid
Now I can combine grids in the user interface, it would be useful to be able to retain any row totals and/or sub totals when I filter on a List or Text formatted column. In the example below, if I filter on Spread=Even, I lose the sub-totals for the numeric monthly data by Entity.