Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Testing a text value

David Kleine-Kracht

David Kleine-Kracht ✭

06/01/15 edited 12/09/19 in Archived 2015 Posts

How can a test be run on a text value to see if it matches?

Tags:

Formulas

0 ·

Comments

David Kleine-Kracht ✭

06/01/15

I figured this out... nevermind. Need to add 'value' quote marks around the text.

0 · Share on Facebook Share on Twitter

This discussion has been closed.

Categories

Trending Posts

Help With Automation
I'm trying to create an automation (alert someone) when a specific cell in my sheet is greater than or equal to $1,500. Right now, when I try to create an automation, my only available triggers are: When a date is reached When rows are added or changed When rows are changed When rows are added I need a trigger for "When a…
Formula Consolidation
This was originally a checkbox column to see if an estimated was within a 10% margin on either side, but now I need it to account for if it is under/over the 10%. Currently, three checkbox columns exist, with the following formulas: EST GOOD - =IF(AND([HR PER UNIT / EST]@row > [10% DOWN]@row, [HR PER UNIT / EST]@row < [10%…
SUMIF sum of the number of cells meeting a text condition
I'd like to add up the number of boxes with the same condition. For example, in column 1 I would like to count how many times I have the word nature. When I use SUMIF to do this it doesn't works.