I am trying to create a formula, checkbox or something that will flag opportunities when they are open and closed within the same fiscal quarter. I currently have a workaround, but it is getting ugly as the time passes by. I have a formula to calculate the quarter when it closes and then other to calculate when it was opened, and then I compare those two. As you can tell, it is a very large IF formula that considers DATES, so it is not efficient. Is there a better way to do this?
