0

More flexibility with multiple column references in formula

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

0 comments

Please sign in to leave a comment.