ContributionsMost RecentMost LikesSolutionsRe: Calculate total days with a condition... That's a good idea. Creating a child table opens a lot more possibilities also. I was hoping for a formula to keep it all in the existing table, but your suggestion is definitely an option. Re: Bi-Directional Data? I apologize for not replying sooner. I was able to accomplish what I wanted using summary fields. I posted this when I first started with Quickbase and since then I have probably completed a least 100 different tasks using the same method and got certified :) Both suggestions are very helpful, but summary fields was the way to go! LJM 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 Bi-Directional Data? Hey everybody! I have a form I created to keep track of inventory in our IT room named "hardware". I have another form I created when issuing equipment (new assignments). New assignments allows me to search the user by employee ID number (that's pulled from another table called employees), and then i have a lookup field that brings up the details of the equipment when I search by serial number. One of the details it pulls is the "hardware status" that can be several predefined options like "in stock" or "Issued". I have a checkbox on the form new assignments, that when checked and the form saved, I would like it to automatically update the field from "In Stock" to "Issued" in the hardware table. Is this possible? Where can I find documentation on how to do this? Thanks! Leo. ------------------------------ Leo Matute ------------------------------ Solved