Hi,
I came across something while trying to write a simple formula that references 2 columns from the same table that did not work.
Example scenario: Add months from one column to a date in another column in the same table to a third column in the same table.
So the formula for that example will be:
DATE_ADD(DATE(!ColumnA, "yyyy-MM-dd"), month, !ColumnB)
Example of desired results:
A B C
2024-02-01 2 2024-04-01
2024-03-15 5 2024-08-15
In general, my request is having more flexibility with column references, as the above example formula is very intuitive, but does not work currently.
Thanks!
Dor