I use this base for creating invoices, and my formulas are not calculating the right numbers, giving me incorrect sums.
GW correctly rolls up (using SUM(values)) hours from a separate table, and the field is formatted as a numeric with two decimal pl...
When a field using FROMNOW() is sorted from A-Z, the sort appears to be based on the first number of the output, rather than the time. Example:
Days should be considered smaller than months, which should be smaller than years. Output should be read ...
We 're a nonprofit, and we keep a database of foundations to which we plan to apply for grants. Some of them have no deadlines, while others have 1, 2, 3, or 4 deadlines per year.
We record each deadline in a separate column/field (we’re using the fr...
A-Z is the only option for the output of FROMNOW(). Yet FROMNOW() is categorized as a Date/Time Function, and the description in the Formula field reference says “Calculates the number of days between the current date and another date.”
Doesn’t it se...
We want to keep track of the next deadline for each foundation, not the last one.
For example, today is June 6, and if XYZ Foundation has deadlines of 1/1, 4/1, 7/1 and 10/1, we’d like to know that the 7/1 deadline is coming up.
