Lookup or Data Mesh for values based on 2 criteria
I have a sheet that I'd like for it to enter a value based on 2 criteria, Site and Job. John Doe gets hired for Job 3 at Site 8 ($131,040).
Is there a formula for Smartsheet to enter the value based on column and row data? Or is there a way to set up Data Mesh to lookup this way?
Help Article Resources
Check out the Formula Handbook template!