Formula to return data based on text in another field (same row) but different sheet

Hi,

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.

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!