I have a maintenance sheet that summarizes budgets and pull the latest week's worth of data that is available. The budget buckets are a set of 8 numbers (ex: 12345678). Some buckets start with zeroes (ex: 00123456). I had to build a workaround with another field instead of referencing the 00123456, and I'd love to know if anyone has any ideas to avoid the "special" formulas (keeping me from applying the formula to the whole column).
"Normal" use: =MAX(COLLECT({Week of}, {Done1}, 1, {Source Name}, [Primary Column]@row))
Workaround for budget that starts with a "0": =IF([Source Prep]@row = 3, MAX(COLLECT({Week of}, {Done1}, 1, {Source Prep}, 1)))
Source Prep is a simple 1, 2, 3 or 4 as needed (I have four buckets that all start with 0). The budget buckets are in the Primary Column.
