I am a little late to the party.
This example is using the Simple Project Manager from Exchange, to add an 'Estimated Start Quarter' field to the Projects Table with the format of "year -QX" -> Example: "2023-Q1". The new field's data type should be a 'Formula - Text'.
The use the following formula:
Year([Est Start Date]) & " - Q" & Floor((Month([Est Start Date])+2)/3)
How this works?
- Month() from quickbase are values 1-12.
- Adding 2 so our return values are 1 - 4. If we did not do this the quarters returned are 0-3.
- Divide by 3 to get the Quarter + Remainder
- Floor() - Returns the largest integer less than or equal to the number x. This will remove the Remainder.
So when the Est Start Date is in February, the math looks like:
- Month() = 2
- Add 2 = 4
- Divide by 3 = 1.3
- Floor(1.3) = 1
Happy Building!
------------------------------
Jonathan Valvano
------------------------------