Automating Date fill in other than Today?

Ariana Arden

I am trying to figure out if it is possible to use the automation function to essentially say, "when column A is filled in, mark in column B Today + 1."

I'm not sure this is possible, but I wonder if anyone has been able to accomplish anything similar with the automation function.

I specifically need this to be an automation and not a formula for the row, due to some other conditions of sheet usage.

Paul Newcome

It won't work through the automation, but you can use the automation to input today's date and then use a separate column to add 1 to the date in the automation column.

Genevieve P.

Hi @Ariana Arden

As @Paul Newcome noted, dates relative to today’s date are not currently supported in a Record a Date workflow (see this Help Article, here).

Please let our Product team know about your use-case and request, identifying why formulas aren't a viable solution, by filling in this form, here!

Thanks,

Genevieve