After reviewing the comments, nearly every single clause you implement has an error. It may be more legible to list them here:
- Your
IF
syntax needs to beIF(logical_test, value_if_true, value_if_false)
. - Your
CONTAINS
syntax needs to beCONTAINS(text, compare_text)
. - Composing these functions should yield
IF(CONTAINS(text, compare_text), value_if_true, value_if_false)
- Composing three nested
IF
statements should yieldIF(condition1, value_if_condition1, IF(condition2, value_if_condition2, IF(condition3, value_if_condition3)))
- You can't call
TEXT
on a field that is already of the type Text. - To return a number, use values like
1
instead of"1"
. - The value
""
is not a valid number. Use0
ornull
instead.