I’ve read numerous examples, but can’t seem to get what I need working.
At a guess, I’d say this is a very simple formula.
Essentially, I have a table with a field ‘Box size’ where people can select small, medium or large sizes. There are also ‘small box with eggs’, ‘small box with coffee’ as just a couple of variations that can be selected.
I have tried to create a formula field that simply searches for ‘Small’, ‘Medium’ or ‘Large’ from the records ‘Box size’ field and places the simplified value into a new field called ‘Simple box size’ so it can be used to display on reports etc.
Is someone please able to show me an example so I am able to get my head around this?
Thanks so much.