Help with AND function

Options

I am trying to have this formula populate a name only if the Component Type is "Teacher Guidance" and the Resource/Object type is blank. I have an incorrect argument set and am not sure how to use AND here or if that is the function I need to use.

=IF(AND([Resource/Object Type]@row = 0, [Component Type]@row = "Teacher Guidance", 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, "") + IF([Hierarchy Level]@row = "Module Overview", ".mo" + "." + [Public Facing Title]@row))))

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!