Formula Help with IF ISBLANK and TODAY...

=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.

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.

  • ShawnaK
    ShawnaK ✭✭

    Thank you so much!

  • 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)

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!