ContributionsMost RecentMost LikesSolutionsRe: Install Status This WeekI have an "Estimated Install Start Date", and my formula is already built and working properly.Install Status This WeekHey folks, I'm tracking installation status (Not Started, Started, Completed) by week of & I have actual start dates. I'd like to create a summary report that shows the status of the installs throughout the week. For example, Site# A starts on Wednesday. I want it to show on Monday that it is "Not Started" and once the site is started (by the "Actual Start Date" being filled in), it will flip to "Started". And once the site is completed (By "Installation Completion Date" being filled in), it will flip to "Completed". What I'm looking for is how to appropriately set the filters on the summary report that will prevent me from having to update it every Monday morning. Thank you!!!Re: Make Formula-Checkbox clickableJust a thought, I could also make it so that when the schedule for the record changes, the "Scheduled Denied by LPM" checkbox unchecks. But I'd need help with that formula too =]Make Formula-Checkbox clickableHey folks, For context- here are my checkboxes involved... 1. "Material Cleared by Supply Chain" 2. "Schedule Approved by LPM" 3. "Schedule Denied by LPM" I want my supply chain guys to review a schedule, approve material to ship, then have the LPM approve the scheduleaftermaterial has been cleared. Here's the functionality I'm looking for: 1. If the LPM selects "Schedule Denied by LPM", I want "Material Cleared by Supply Chain" to automatically uncheck. 2. When supply chain re-checks "Material Cleared by Supply Chain" at a later date, I want the "Schedule Denied by LPM" checkbox to uncheck. I'm willing to make changes, if making the two checkboxes into a Yes/No field entitled "Schedule Approved by LPM", that's fine. I'm trying to avoid making a bunch of ghost checkboxes to pass checks along. Keep in mind that I want to keep all checkboxes clickable from the grid edit view! Thanks for your help!