IF formula or Nested IF

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!




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!