I have a field for "days remaining" for a deadline.
I have the calculation entered as such "Certification Action date - Get ( CurrentDate )" where Certification action date is the date entered which is the deadline. When I create a record that day the field "days remaining" works fine. But "days remaining" shows the same value everyday, I need that updated everyday or whenever I open that record. Let me know how that can be achieved. Also is there any way where I can achieve the following-
When the days "days remaining" field falls below 30 there will me an email sent to me to remind it?