Calculate total days with a condition...
I'll try my best to explain... I have a dropdown field [Status] with 2 options. - For now we'll label them "Option 1", and "Option 2". I have a date field [O1_DATE] that puts in the "current date" when Option 1 is selected via dynamic rule. When Option 1 is selected, a numeric formula field [FORMULA1] calculates [today] - [O1_DATE] (using ToDays and ToDate), and this gives me a total number of days Option 1 has been selected. so far no problem... Now lets say I change [Status] to Option 2 and 10 days later I switch back [Status] to "Option 1" for 20 more days. How do I get it to only calculate the days that "Option 1" was selected? In a nutshell, I just need to know the total time a record had the status of "Option 1". Thank you and I look forward to your suggestions. LJM