Can I use variables in formulas

[James_Samuel]

I want to put the result of another field in place of [#] in the formula: DATEADD([date], [#], ‘units’)
I’ve tried enclosing the field name in [] {} () but nothing seems to work.

Am I missing something?

[James_Samuel]

That field works, as long as it’s a number field only - as I edited in the above reply, it seems copying from the lookup and pasting into a number field for every new record is the only solution.

Any idea for how to remove the extra time format in the result of this DATEADD formula?

[Tuur]

Yup. Simply use an extra DATETIME_FORMAT. :slightly_smiling_face:

Also, I came up with a possible workaround. Please try a rollup field instead of the lookup.

[James_Samuel]

Awesome - Rollup and DATETIME_FORMAT all works beautifully now - thanks a bunch for that workaround! :slightly_smiling_face:

(from down under in New Zealand)

[Tuur]

My pleasure. No worries! :winking_face: