Bring the data in a cell over to another sheet based off of other conditions in a row
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")
Best 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
-
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}, ""), " / ")
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!