Value function

Options
Preston
Preston ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Having trouble with the formula below. Version 1 works and extracts what I need from a cell. I need to then convert that to a numeric value. Currently I get #invalid value. I'm missing something, and I bet it's dumb. ;)

Β 

  1. =MID([Active Link]@row, (FIND("/", [Active Link]@row) + 1), ((FIND("*", [Active Link]@row) - 1) - (FIND("/", [Active Link]@row))))
  2. =VALUE(MID([Active Link]@row, (FIND("/", [Active Link]@row) + 1), ((FIND("*", [Active Link]@row) - 1) - (FIND("/", [Active Link]@row)))))
Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!