I'm Trying to flag if a colum says RISK but it comes up as #UMPARSEABLE

Jlind

Jlind ✭✭

11/03/21 in Formulas and Functions

Help please

=if(Status@row=RISK, 1,0)

Is not working

Tags:

Formulas

0 ·

Answers

Paul Newcome ✭✭✭✭✭✭

11/03/21

Try putting quotes around "RISK".

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter
Jlind ✭✭

11/03/21

Thank you so much @Paul Newcome it worked! 😊

0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

11/04/21

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Trying to complete an INDEX MATCH formula
I am trying to create an INDEX/MATCH formula and the criteria used between the sheets for MATCH is: Sheet 1: First Name and Last Name in one column Sheet 2: Has 2 columns: first name and Last name I've tried to write a formula to combine the names on sheet 2 =[First Name]@row + " " + [Last Name]@row I've written many…
Formula column that counts the number of rows. Each row having its own number
The issue I am trying to resolve is that when the sheet has 500 rows i want automation to move a number of them elsewhere. lets say i want to move everything numbered from 350- 500. so i need each row to know how many rows there are so i can add automation so over 350 move rows. the problem i am having is i cant use…
I need to add a formula to check box column if SSN is in 2 different SmartSheet.