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

Options

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
Options
Try putting quotes around "RISK".

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

11/03/21
Options
Thank you so much @Paul Newcome it worked! 😊

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

11/04/21
Options
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

How do I pull in a value using 2 criteria?
I want to use Project Name and Resource name as a criteria to pull hours worked into a different sheet. Please help.
VLOOKUP and COUNTIFS
Hi all, Hoping to get some help with a LOOKUP/COUNTIF formula. I'm trying to create a grid that counts issue location by month. I've created this column in the source sheet which is the range for the VLOOKUP. The sheet that this information needs to be pulled to: I'm struggling to create a formula that will count each…
Whats the formula to find todays date between a range of dates to provide a value?
i need a formula to find todays date between the start date and end date, then provide the current sprint