JP
3 months agoQrew Member
Scheduling Formula needed
looking to create a formula or rule to do the following interior Date Field to not allow changes if interior status is confirmed and less then 2 weeks from current week.
- 3 months ago
I think the easiest way is to make a formula field called [Lock Interior Date?]
[Interior Status ] = "Confirmed"
and
Todays([Today() - [Interior Date]) <= 10
Then put that field on the form, even in a hidden section and use it in a form rule