Help using NOT function

I want this column to show "N/A" or be blank if the Resource/Object type contains "guidance." If the type does not contain "guidance" I want it to populate the formula that starts at lower. This shows an incorrect argument set error when entered. Any advice would be great!


=IF(NOT(CONTAINS("guidance", [Resource/Object Type]@row, "N/A"), LOWER(Curriculum@row + ".g" + [Grade/Level]@row + ".m" + Module@row + IF([Concept/Topic/Arc]@row <> "", "." + [Concept/Topic/Arc]@row + IF(Lesson@row <> "", ".l" + Lesson@row)) + "." + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Public Facing Title]@row, " ", ""), CHAR(34), ""), "-", ""))))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!