Correct grammar: Andrew's stupid or Andrew is stupid?

They both work, because the word Andrew's is just combining Andrew and is. The word Andrew's can also mean belonging to someone, so honestly I would just use the phrase Andrew is stupid. Both will work though. ;)