Link cells or IF Function
I am newish to SS and I'm trying to pull data between 2 sheets and I'm not sure if I need to use the Link cell function, IF Formula or if there is another formula I should use. But here is what I am trying to achieve.
I have 2 sheets, #1 and #2. On sheet #2 I want to pull a date from #1 but the date pulled would be based on 2 different cells (not next to each other), which every has a date entered. Sheet #1 will only have a date entered in one or the other cells, based upon how the project moves along. I want sheet #2 cell to remain blank, until said date is entered
Thanks for the help!
Help Article Resources
Check out the Formula Handbook template!