I am unable to get =IF(Has formula to work

jehup
jehup ✭✭✭
in Formulas and Functions

IF(Has not working for me

· Share on FacebookShare on Twitter

Answers

  • jehup
    jehup ✭✭✭
    I am unable to get a simple =IF(Has formula to work. #Unparseable, please let me know what the error is. I want to count the same items from the Project column and provide me a 1 or 0. Thanks image.png
    · Share on FacebookShare on Twitter
  • Corey W.
    Corey W. ✭✭✭✭✭

    Your right brackets on the range are in the wrong place. Try [Project]10:[Project]22. Or remove the numbers altogether to reference the entire column.

    · Share on FacebookShare 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!