Challenge: Create a Customize Formula Field (2nd part of the challenge)
I do not see/not have access to/can't select Region or Zone in the column
- From the Functions list, select TEXT, and then click Insert Selected Function.
- In the formula, highlight value.
- Click Insert Field and select Account> from the second list on the Insert Field overlay that appears.
- From the new list that appears, select Region, then click Insert.
- Click at the end of the formula to position the cursor, and then click Insert Operator and select &Concatenate.
- At the end of the formula, enter "/" (including the quotation marks).
- Click Insert Operator, and then select &Concatenate.
- From the Functions list, select TEXT, and then click Insert Selected Function.
- In the formula, highlight value.
- Click Insert Field and select Account> from the second list on the Insert Field overlay that appears.
- From the new list that appears, select Zone, and then click Insert.
Below is what I see/have:
Thanks for your help!
13 answers