While "sweet" can be both a noun and an adjective, it's most commonly used as an adjective to describe something that has a pleasant sugary taste.
For example:
* "The cake was sweet."
* "The flowers have a sweet fragrance."
* "She had a sweet smile."