Formula Help with IF ISBLANK and TODAY...

ShawnaK
ShawnaK âś­âś­
in Formulas and Functions

=IF(ISBLANK[Date Filled]@row), [Date of Vacancy]@row - Today@row, [Date Filled]@row-[Date of Vacancy]@row)

I keep getting the #UNPARSEABLE error and I can't seem to figure out why. Any help would be greatly appreciated.

· Share on FacebookShare on Twitter

Answers

  • Mark.poole
    Mark.poole âś­âś­âś­âś­âś­âś­
    edited 05/31/24


    you forgot the beginning parentheses for the is blank function.

    =IF(ISBLANK([Date Filled]@row), [Date of Vacancy]@row - Today@row, [Date Filled]@row-[Date of Vacancy]@row)

    If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.

    · Share on FacebookShare on Twitter
  • ShawnaK
    ShawnaK âś­âś­

    Thank you so much!

    · Share on FacebookShare on Twitter
  • ShawnaK
    ShawnaK âś­âś­

    It is still not working

    =IF(ISBLANK([Date Filled]@row), [Date of Vacancy]@row - Today@row, [Date Filled]@row-[Date of Vacancy]@row)

    · 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!