Forum Discussion
Adamsibilski
May 10, 2021Copper Contributor
Custom formatting advice
Good Morning. I have come across a problem with custom formatting. I have created checklists to use in our workplace. questions are simply answered with yes/no or N/A using drop down menus. fee...
Johnthegreen
Mar 16, 2023Copper Contributor
IS it possible to make one that does this:
Enter:
1 is "Dismisssed"
2 is "In Progress"
3 is "Settlement"
4 is "Guilty"
Johnthegreen
Mar 16, 2023Copper Contributor
[=1]"Dismissed";[=2]"In Progress"
[=3]"Settlement";[=4]"Guilty"
I tried the above, but 3 and 4 dont work 1 and 2 do
[=3]"Settlement";[=4]"Guilty"
I tried the above, but 3 and 4 dont work 1 and 2 do
- HansVogelaarMar 16, 2023MVP
In sch a custom number format, you can use only two sections of the form
[=value]format
So instead of formatting the value itself, use a formula in another cell to display "Dismissed" etc.