cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ljkeefe
Helper I
Helper I

Tried If and or statement - Circular Reference warning

I have a scheduling calculator primarily based on 3 date picker fields (Every Monday, 2nd Tuesday, and 1st&3rdTuesday). The date is manually entered into the Every Monday date picker, the 2nd Tuesday picker calculates the 2nd Tuesday based on the date selected in the Every Monday date picker, and the 1st&3rdTuesday date picker is calculated based on the date that gets calculated in the 2nd Tuesday date picker. I'd like to add the possibility of the user manually entering in EITHER the Every Monday or the 1st&3rdTuesday date picker, and calculating the dates either way. I've tried using an IF statement in both the Every Monday and 1st&3rdTuesday date pickers (once with the IF statement in only one date picker and another time with the IF statement in both) and I get a circular reference error. I've also tried adding an OR statement and get an error too. I've also tried modifying the 2nd Tuesday date picker with a nested IF statement and an OR statement to adjust for calculating the date from the EveryMonday date picker and the 1st&3rd Tuesday date picker, and I get an error. Is it possible to accomplish what I need or will I have to find a workaround?

ljkeefe_0-1631658076046.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
ljkeefe
Helper I
Helper I

Found a better way to do it..nevermind!! 😀

View solution in original post

1 REPLY 1
ljkeefe
Helper I
Helper I

Found a better way to do it..nevermind!! 😀

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,755)