Workaround for indenting in a cell

Monica Solar
Monica Solar ✭✭
edited 04/12/23 in Formulas and Functions

Hi Everyone,

I'm trying to write a formula that will indent the items in my Activity Name column based on the value in my Project Plan / WBS Hierarchy column.

For example, if the Project Plan / WBS Hierarchy column has a value of Milestone, indent the Activity Name cell two spaces.

I can get the formula to work if I use dashes or other characters, but not with spaces, does anyone have any suggestions?

Here is the formula I am using, without characters...just spaces...

=IF([Project Plan / WBS Hierarchy]@row = "Workstream", "" + [Activity Name]@row,

IF([Project Plan / WBS Hierarchy]@row = "Subfunction", " " + [Activity Name]@row,

IF([Project Plan / WBS Hierarchy]@row = "Milestone", " " + [Activity Name]@row,

IF([Project Plan / WBS Hierarchy]@row = "Task", " " + [Activity Name]@row,

IF([Project Plan / WBS Hierarchy]@row = "Sub Task", " " + [Activity Name]@row)))))


thanks!

Monica

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!