Current date in a column

Yashwant Singh

working 2 columns. need current date if first column is approved , using today() function but date will change in frequently because today() function giving current date only..

please share some solution....

Andrée Starå

Hi Yashwant,

There are a couple of workaround possibilities.

• Set up a workflow that copies the row to another sheet and then uses a formula to show the information in the cell as needed.
• The third-party service, Zapier, is an excellent option for this scenario. Is that an option for you?

Would any of those work?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!