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?
Help Article Resources
Check out the Formula Handbook template!