Forum Discussion
Solved
If a range contains text then return a single value
Hi there, I have the below column in a tab called "Product Ideas": New ingredients or comps oat syrup almonds stuff I want to create a formula in a new cell where...
Thank you very much for the help. When you say it's not designed in the most effective way, do you have any recommendations?
lilian51129 Personally I prefer to capture data in a tabular format. The Product Ideas tab already looks like a summarized overview to me. Conditional formats, merged cells, borders and empty rows, spaces to insert pictures etc. All this makes it more difficult to create the kind of Overview you are asking for. It also transposes the Product Ideas from below each other to beside each other. Doable, but more complicated.
With only few ideas, I guess it's OK, but I fear it will be difficult to maintain for greater numbers. Haven't really given it much thought how to approach it from scratch as I'm neither familiar with your business nor with the purpose of this overview.
- Thanks it makes sense. I work in product developent and the company does only one or two new products at a time so I have put five product ideas just in case, not too many. The overview is just a summary for the senior managent to scan through in a glance and see what we are wanting to develop.