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

VLOOKUP or IF?
Hello, I am not sure if I should be using VLOOKUP or an IF/THEN statement or a combination of the two. Any help is greatly appreciated. Thank you. Problem Statement: I want the PWS link to auto populate based on the Areas of Support selection. Both columns are dropdowns. Current attempt gives me a circular reference.…
Getting a specified drop down selection based on the range from another cell
I have a sheet that is for prioritization purposes, there are multiple columns that aggregate value into a "Total Score" column, I want my "Priority" column to auto populate a value based on the value in total score ie if value 0-20 it should be P4 if it is 21-40 P3 if 41-60 P2 if 61-80 P1 if 81-100 P0. I used the…
Control Center & Multi-select dropdown
Hello. I'm looking for some feedback on a control center process we've built. We have an intake sheet with standard and optional department assets depending on intake data. To mark which assets we need to create, we have multiple columns with multi-select dropdowns for each asset by department name. What my goal was to…