Major project on dogs

I have a dog profile, and a column about the things that they done with him as related, when they make a closing document that dog status changes to DEAD, in my country we put flea collars for free to every dog and its valid for 6 months, I already made a “collared” status if the person creates a collar document, I made a collaring date and auto computed expiration row that calculates 6 months ahead, but I need an expression or automation that changes the dog status to “delayed collaring” when the collar expiration date row passes the time and if the person creates another collaring document the status changes to “collared” again, is this impossible?

Yes. I think it’s possible in a virtual column with expressions. You would need to use IF() expressions and compare the collaring date 6 months ahead with NOW(), DATE(NOW()), or TODAY():

1 Like