Formula to return data based on text in another field (same row) but different sheet
Is it possible to write a formula to recognize specific data from a text field and return data from another field in that same row but in a different sheet?
For example, I am putting together a dashboard to display the health, trend and status of the 6 top summary tasks in my schedule. I'd like a formula that would identify "1. Quality and Variety" (in the Task/Primary field) and then return the health color symbol in the "Health" field. If I am writing the formula on the same page using the specific row I can make it happen but if I am trying to write the formula on a different sheet to use for my dashboard, it doesn't work.
Is this even possible? And if so, how would I do it? Thank you in advance.
Help Article Resources
Check out the Formula Handbook template!