Return a value based on multiple cells



I want to check a series of cells and return a value of one cell based upon the others not being blank.

If I have columns:

Original Current Updated Actual Most Accurate

I want to populate "Most Accurate" with the value in Actual.

If Actual is blank then I want to pull "Updated" cell value

If Updated is blank then pull value in CURRENT into "Most Accurate"

If Current is blank then pull value in ORIGINAL into "Most Accurate"

If Original is blank the return "NA"

The end goal copy the value that is in "Most Accurate" and link it to another sheet for a dashboard reporting.


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!