Formula for new column to get a hierarchy view in report

delaurellc

Morning,

I am working on code to get some type of hyerarchy view in a report

I added the below code and it is just coming up as blank

I spread the code out a bit so you could see what I was trying to do, where did i go wrong?

=IF(CONTAINS(0, [Task Level]@row), [Task Name]@row,

IF(CONTAINS(1, [Task Level]@row), "--" + [Task Name]@row,

IF(CONTAINS(2, [Task Level]@row), "----" + [Task Name]@row,

IF(CONTAINS(3, [Task Level]@row), "------" + [Task Name]@row,

IF(CONTAINS(4, [Task Level]@row), "--------" + [Task Name]@row,

IF(CONTAINS(5, [Task Level]@row), "--------" + [Task Name]@row,

IF(CONTAINS(6, [Task Level]@row), "----------" + [Task Name]@row))))))))

Find more posts tagged with

Accepted answers

Paul Newcome

Instead of the CONTAINS function, try making it equal to the number:

=IF([Task level]@row = 0, [Task name]@row, ....................

You can also save yourself some keystrokes by using the nested IF to generate just the dashes and then add the task name to the end of the nested IF.

=IF(.....IF(.....IF(.....))) + [Task Name]@row

All comments

Paul Newcome

Instead of the CONTAINS function, try making it equal to the number:

=IF([Task level]@row = 0, [Task name]@row, ....................

You can also save yourself some keystrokes by using the nested IF to generate just the dashes and then add the task name to the end of the nested IF.

=IF(.....IF(.....IF(.....))) + [Task Name]@row

Paul Newcome

And this actually inspired me to try something out that will simplify everything for you.

=LEFT("------------", [Task Level]@row * 2) + [Task Name]@row

The above should work to apply two hyphens for every level. So level zero would have none, level 1 would have 2, level 2 would have 4, so on and so forth all the way up through 12 for level six (which is what your formula looks like it is currently doing).

delaurellc

Thank you that worked with code completed like this:

=IF([Task Level]@row = 0, [Task Name]@row, IF([Task Level]@row = 1, "--" + [Task Name]@row, IF([Task Level]@row = 2, "----" + [Task Name]@row, IF([Task Level]@row = 3, "------" + [Task Name]@row, IF([Task Level]@row = 4, "--------" + [Task Name]@row, IF([Task Level]@row = 5, "--------" + [Task Name]@row, IF([Task Level]@row = 6, "----------" + [Task Name]@row)))))))

Paul Newcome

Happy to help. 👍️

You can also save yourself a bit of typing in the future using the LEFT formula I provided above.

delaurellc

thank you!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.