Turn Flag on if there is a Date in Date Completed

Simple question but not for a newbie! I would like for the Task Complete flag to show when the Date Completed field has a date in it and to not show a flag if no date. I know this should be a simple IF statement but I got stuck. Perhaps use ISDATE?? I tried this in the column for the flag: =IF(ISDATE[Date Completed]13, 1,0). Thoughts?

Best Answer

  • Pamela Wagner
    Pamela Wagner ✭✭✭✭✭✭
    Answer ✓

    Hi everyone, I can't see how to delete a question or turn it off but I kept looking through the past questions and found one that was similar that I used and works just fine, take a different track: =IF([Date Completed]13 <> "", 1).

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!