Performing Calculations if Cell = ""

mwiggins ✭✭✭✭
edited 12/09/19 in Smartsheet Basics

Hello Community, 


I have a question on what the optimal solution is to a calculation I would like to perform.

Here is what's there:

In one column I have job title - based on if that cell = "[title X,Y...]" then I'd like to perform a calculation based on four other columns that have calculated values in them - but the weight of those calculations will change based on what position is listed.

For instance, 

If they are Title X, then AVG(all scores), if they are Title Y, then AVG(scores 1-3)+(score 4 * 2)


Please let me know if this is possible or if I should go another route!

Thank you