Hello
I have (2) sheets I am working on. One is my Main_Running project sheet.
The 2nd, I would like to populate depending on whether a column in the Main is "starred"
If Column_is_starred; then I want it to pull in information from a separate Main_sheet column.
I would like the 2nd sheet to only be populated if/when the Main_sheet has a starred value.
eg if there are 100-rows in Main_sheet, but only 25-starred; then Sheet_2 should only have 25-rows populated.. (not wanting null or n/a returns.
This is what I have; understanding the return of "0" is not ideal, and likely errors elsewhere along the way..
=IF(({[Running Project Revamp 24] Range 1} = 1), {[Running Project Revamp 24] Range 2}, 0)
Thoughts?! Thank you.