IF formula or Nested IF

Options
Tina
Tina ✭✭✭✭
edited 12/09/19 in Formulas and Functions

I'm trying to create a formula using the Flag symbol and a % Allocated to Project column.  I would like the flag to raise if the % Allocated to Project column is 50% or less.  If greater than 50% or Blank I would like the flag to stay down. 

I thought I could accomplish this with =IF([% Allocated to Project]@row< 0.5, 1, 0) however, the flag still raises when the field is blank.  

Any help would be appreciated!

 

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!