Have a cell show blank if there is text in another cell

kpierson109

I want the column Strapi Subsection Code to be blank if there is any text in the Strapi Page code column. How would I add this to this formula?

=IF([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)) + ".tg." + IF([Hierarchy Level]@row = "Module Texts", "mt.") + IF([Hierarchy Level]@row = "Module Overview", "mo.") + IF([Hierarchy Level]@row = "Assessments", "as.") + IF([Hierarchy Level]@row = "Appendices", "ap.") + IF([Hierarchy Level]@row = "Prologue Overview", "po.") + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Public Facing Title]@row, " ", ""), CHAR(34), ""), "-", "")))

Hollie Green

=If([Strapi Page code]@row<>"","",IF([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)) + ".tg." + IF([Hierarchy Level]@row = "Module Texts", "mt.") + IF([Hierarchy Level]@row = "Module Overview", "mo.") + IF([Hierarchy Level]@row = "Assessments", "as.") + IF([Hierarchy Level]@row = "Appendices", "ap.") + IF([Hierarchy Level]@row = "Prologue Overview", "po.") + SUBSTITUTE(SUBSTITUTE(SUBSTITUTE([Public Facing Title]@row, " ", ""), CHAR(34), ""), "-", ""))))