We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!Submit Feedback
I have a challenge with the last exercise
I ran the following in the formula tool:
IF Length([Safety Code])>8
THEN Left([Safety Code],
elseif Length([Safety Code])=6
then PadLeft([Safety Code], 2, "SC")
ELSE [Safety Code]
but cant get the desired result. It did not Padleft "SC'" to record output 1.
Can someone please help me with this?