Forum Discussion
PaulD98L
Jun 05, 2020Copper Contributor
Change numbers in column to text
Hello, For some of you a simple issue, but for i am struggling for long to do this. I have two columns which i want to use: the one with numbers of our shops en one with hours people worked a...
- Jun 06, 2020
Paul, let me illustrate on this simple model
Even better to use Table for the mappings, it's easier to support and not necessary to adjust formulas for expanded ranges or use dynamic ranges formulas.
That could be like
if we name the table as shopNames.
Please check in attached file.
SergeiBaklan
Jun 06, 2020Diamond Contributor
Paul, let me illustrate on this simple model
Even better to use Table for the mappings, it's easier to support and not necessary to adjust formulas for expanded ranges or use dynamic ranges formulas.
That could be like
if we name the table as shopNames.
Please check in attached file.
PaulD98L
Jul 14, 2020Copper Contributor
- SergeiBaklanJul 14, 2020Diamond Contributor
Paul, glad to help