What I am trying to achieve is that if the column “Date Month” (which is the Date text pulled out from Date) is a certain value like 3, 4, 5, etc that my Select List column will pick from the drop down list for Q1, Q2, Q3, etc. Any help would be great as I feel like I am banging my head on a wall trying to get this formula to work.
Hi Nate,
Welcome to the community!
To get the quarter from a date you can use this formula:
"Q" + RoundUp(thisRow.Date.Month()/3,0)
3 Likes
Thanks Pablo,
At first it didn’t seem this would solve my issue, however, I see this will grab a quarter instead of having a list to select from based on a value in the Date Month column to affect the Select List column. A simpler version of what I was trying for, thanks!
1 Like
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.