Lookup / find value formulae


Hi there, need help with the formulae.

Sheet 1 is where the data is input and will look like that

Sheet 2 is my summary for calculation and formuale to populate graphs

the third table is how the $ value would get populated for building graph. Can you please confirm the formulae


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!