I'm in the real estate business and trying to use Globiflow to help us with calculating how long a house has been on the market - expressed by calculation field "Days on Market" or "DOM". Once DOM hits 30 days, I want to be able to have the DOM field turn red, or have a big "!" icon to show it's overdue, and also create a notification of some sort to us that we need to look at it.
Secondly, once the field "Status" changes from "Listed" to "Escrow" I would like the DOM field to stop counting. So if it took 60 days from "List Date" to "Escrow Date" the DOM field should stop and remain at 60.
The 3 fields we have to build this equation are: List Date, Escrow Date, and a category field where status would change from "Listed" to "Escrow".
(Then I also need to do the same thing in reverse for counting down days until construction is supposed to be completed)
Please sign in to leave a comment.