WBS numbering

toshiaki

SmartSheet introduced me a template showing WBS numbering which reflects "Task" column indent like 1, 1.1, 1.1.1.

This formula is "=IF(Prefix@row <> "", Prefix@row, "") + Suffix@row”.

It works on the template. I copied and past the formula to the other sheet but does not work. I attached screen shots.

Anything wrong?

Find more posts tagged with

Accepted answers

KPH

Does your other sheet have columns called Prefix and Suffix?

This formula

=IF(Prefix@row <> "", Prefix@row, "") + Suffix@row

Says if the cell on the current row in the column called Prefix is not equal to "" (i.e. is not empty) then return the value of the cell on the current row in the column called Prefix.

If that is not true (i.e. the cell is empty) return "" (nothing).

Then add to that, the value in the cell on the current row in the column called Suffix.

If you do not have the columns Prefix and Suffix, the formula will not work.

All comments

KPH

Does your other sheet have columns called Prefix and Suffix?

This formula

=IF(Prefix@row <> "", Prefix@row, "") + Suffix@row

Says if the cell on the current row in the column called Prefix is not equal to "" (i.e. is not empty) then return the value of the cell on the current row in the column called Prefix.

If that is not true (i.e. the cell is empty) return "" (nothing).

Then add to that, the value in the cell on the current row in the column called Suffix.

If you do not have the columns Prefix and Suffix, the formula will not work.

toshiaki

The columns, Prefix and Suffix on the template were hidden do I could not undestand.

Now I understand. Thank you for yor answer.

KPH

That's great. Glad I could help.

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.