MAX function, formulas in cells in range

Options

I am using the MAX function to pull the max value from multiple cells. Some cells have formulas and currently are not pulling into the MAX formula. How can I fix this?

Answers

  • Kelly Moore
    Kelly Moore ✭✭✭✭✭✭
    Options

    Hey @Lisa Huggler

    Often formulas pull data into a cell but, in the process, make a number behave as text instead of a number. The VALUE function tells a number to behave as a number instead of text. You could try wrapping a VALUE function around your entire formula in the cells that are not being pulled in. Sometimes you can add the VALUE as criteria within the MAX formula, depending on the data and functions being used within the formula.

    If used within cells not being pulled in:

    =VALUE(Your entire formula, including all parentheses)

    If the above doesn't work, is it possible for you to give us a screenshot of the sheet and your max formula? This will help us narrow down what might be the issue.

    Kelly

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!