If function based on TBD cells w/3 options
I'm trying to create an email subject line helper cell for my projects. Different project numbers are added throughout my project's life. I start with a VRE#, then later get a Site#, then lastly get a Store#.
Those numbers are always added in that order.
Can you help me write a function for:
If site# and store# are TBD use function in line 10
If site# is TBD use function in line 9
If all 3 are present, use function in row 8
I added a ' in the first column for you to see the functions for each. Hope this makes sense!