Help Finding the correct formula to gather a piece of data
I am new to SmartSheet and am trying to work on an impact heat map for various projects across an organization.
In one column I have the project and its subtasks, then stakeholder group, the month of impact, and the degree of change (high, medium, low). I want to link that spreadsheet to another that will just shows the degree of change (in color) in the correct spot.
I was thinking I would need an index function or an if/then but I am not sure.
The sheet I need it to feed (colors are there as a sample of how it should look in the end):
I want it to pull the coloring from the first sheet into the second sheet in the correct place (month, project, stakeholder)
I don't think it will solely pull the color and understand I may need to assign a value (0,1,3,5) and then conditionally format it to pop out the colors.