Bring the data in a cell over to another sheet based off of other conditions in a row

mballen

What would be the best way to bring the data in a cell over to another sheet based off of other conditions in a row?

Example:

=IF(AND({Sheet A Type} = "Project Status", {Sheet A Status} = ""), {Sheet A % Complete}, "0")

Find more posts tagged with

Formulas

Accepted answers

mballen

Thanks @Genevieve P. !

With a slight change to your example we found a formula that worked!

=JOIN(COLLECT({Sheet A % Complete}, {Sheet A Type}, "Project Status", {Sheet A Status}, ""), " / ")

All comments

Genevieve P.

Hi @mballen

I would use a JOIN(COLLECT formula for this. It will Join together all the row values in one column that meet your criteria into one cell.

For example, something like this:

=JOIN(COLLECT({Sheet A Task Names}, {Sheet A Type} = "Project Status", {Sheet A Status} = "", {Sheet A % Complete}, 0), " / ")

Then this would Join all the Task Names with a / between the names.

Let me know if this works for your purposes!

Cheers,

Genevieve

mballen

Thanks @Genevieve P. !

With a slight change to your example we found a formula that worked!

=JOIN(COLLECT({Sheet A % Complete}, {Sheet A Type}, "Project Status", {Sheet A Status}, ""), " / ")

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.