Combining Formulas in 1 Cell

Hello,

I have a column with this formula: =PARENT([Task Name]@row) which is assigning my rows the name of the parent so I can create swimlanes in the card view sorting my tasks by the parent project name.

In the same column I would like to also have an option to override the first formula with this formula: =IF(Status1="Complete", "Complete"). I'm using that formula to override the parent project name so I can create a swimlane with all the Completed tasks.

Question1: If I want to use both formulas in the same Task Name cell, how do I combine them?

Question 2: Is this the best way to accomplish being able to have card view swimlanes for the parent project along with a "Complete" swimlane that ensures only "Not Started" and "In Progress" tasks are left in the project swimlanes and completed items are lumped into one lane?

Thanks!

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

Try something like this...

=IF(Status1="Complete", "Complete", PARENT([Task Name]@row))

bbene

Thanks Paul. Unfortunately, it didn't work. Even though the Status was changed to "Complete" the Project Name still showed as the parent row task name. It didn't update to "Complete" for the project name.

Any other ideas? Is there another way to accomplish the goal I'm trying to get to?

Paul Newcome

Lets try making sure we are referencing the same row in both cell references...

=IF(Status@row="Complete", "Complete", PARENT([Task Name]@row))

bbene

It worked! Thank you so much.

Paul Newcome

Happy to 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.