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

11/19/21
Accepted

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")

Tags:

Best Answer

  • mballenmballen
    Accepted Answer

    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}, ""), " / ")

Answers

  • 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

  • mballenmballen
    Accepted Answer

    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 or Register to comment.