Flag Formula

Angelique H.

Angelique H. ✭✭✭

12/16/21 in Formulas and Functions

How do you raise flag for a simple Yes/No condition using an IF statement? I continue to receive #Unparseable and #IncorrectDataSet errors.

Thanks

0 ·

Best Answer

Devin Lee ✭✭✭✭✭

12/16/21 Answer ✓
You are missing an argument.
=IF([Yes/No]@row = "Yes", 0, 1)
0 · Share on Facebook Share on Twitter

Answers

Devin Lee ✭✭✭✭✭

12/16/21 Answer ✓
You are missing an argument.
=IF([Yes/No]@row = "Yes", 0, 1)
0 · Share on Facebook Share on Twitter
Angelique H. ✭✭✭

12/16/21

Thank you

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

Formula to SUM = 0 Why?
I created a formula to sum the values in other formula columns but the return is "0". I have created other sheets with the same type of formula and the return is correct. How is the return 0 on this formula. It appears to be correct.
Label Status Dot Help
Hey all! I am trying to add the color symbol dots to align with status and I've tried so many formulas, I cannot for the life of me figure this out. Nothing crazy in this sheet, just want to align the status to the color of the dot. If Status = Complete —> Green If Status = In Discovery, In Process, In Review —> Yellow If…
HELP!!! Max Collect for Dates
I utilize Smarthsheet to manage a hospital schedule. I need to find out the last time a staff member worked. I have been playing around with Max Collect and constantly failing… #UNPARSEABLE Things to note: The Primary column shows the name of the staffer multiple times with multiple different dates under the Date Worked…