Expression not syncing or updating with Appheet using App formula

[bman22]

Hello, I've used the expression below where I'm trying to update the value of a row as a message gets older with various different text. This is supposed to happen when AppSheet syncs, but even though the expression tests perfectly fine, the values don't appear anywhere on my app at all. I attempted to place it in the App formula and it doesn't seem to do anything so I'm pretty confused right now and am unsure what to do next. I could also hard code an expression into Google Sheets, but I was trying to figure this out in AppSheet. I was using the Text Type, didn't know if that had anything to do with it

IFS((HOUR(TODAY()-[Date Posted]))/24<=5,"New",(HOUR(TODAY()-[Date Posted]))/24<=10,"1 week+",(HOUR(TODAY()-[Date Posted]))/24>10,"archive")

[Marc_Dillon · Accepted solution]

Virtual Column or Real?

Virtual Columns re-evaluate their App Formula upon every sync. Real columns only do so when the record is edited.

[bman22]

Hell yes thank U!!!