Is it possible to use ISTEXT or ISNUMBER with a cell that is the result of a formula?

Allen Vance

It appears not, but I'm wondering if there's a work around. I have a column with numbers that sometimes have letters at the end (in which case I need to address and possible remove them). Sometimes there are letters at the beginning of the number in the column, but those are needed so I can't use ISTEXT or ISNUMBER on the whole cell. I can get the last character(s) using a RIGHT formula, but I can't evaluate the resulting value in that cell with ISTEXT or ISNUMBER--it always returns that it is text or isn't a number (presumably because it's looking at the formula itself rather than the resulting value).

Andrée Starå

Hi @Allen Vance

I hope you're well and safe!

I might have a Workaround. (see details below)

Add a so-called helper column and use the RIGHT formula to get the last character and then we'd copy that to another sheet and then collect it back to another so-called helper column, and then you'd evaluate if it's TEXT.

Make sense?

Please have a look at my post below with a method I developed.

More info: 

https://community.smartsheet.com/discussion/68589/lock-or-store-date-value-solution-without-using-zapier

Did that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!