Automating Date fill in other than Today?
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.
Help Article Resources
Check out the Formula Handbook template!