Return the value from the column that is not blank

System
System Employee
in Formulas and Functions
This discussion was created from comments split from: If multiple cells are not blank - check the box.
· Share on FacebookShare on Twitter

Answers

  • Haley Gehris
    Haley Gehris ✭✭

    I am trying to evaluate 3 different columns and I want the value from the column that is not blank to be returned. There will only be a value in 1 of the 3 columns. How can I string IF statements together and use the ISBLANK formula to accomplish this?

    · Share on FacebookShare on Twitter
  • ShaneP
    ShaneP ✭✭

    If there is only ever 1 cell that will have a value, can't you just add each cell together? E.G you have column A,B,C. Create Column D which has =A+B+C

    · Share on FacebookShare on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!