Hello, I am trying to generate a formula that would help with the following:

Jonathan Martinez

I have projects that have a weekly status statement box that PM's edit every week with new project information, below this cell is another cell that has the status statement updated date...we have a problem with PMs filling out the date so I would like the date cell to automatically change anytime someone makes an edit in the cell above for status update...any ideas?

Paul Newcome

I would suggest replacing this cell with a Modified (by) column.

Jonathan Martinez

Yes, that seems to be the way. Do you know why I would not be able to use the Modified by column, when I go to insert a new row, it will not allow me to select the modified by.

Andrée Starå

Hi @Jonathan Martinez

I hope you're well and safe!

You could use a Workflow with the record a date feature for each time it changes.

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jonathan Martinez

Thanks for the help @Andrée Starå ....I tried this layout in another sheet

If I have the modified by column, can I link that returned value into a cell within the same sheet (different row but same column as the details) If I try to link the cells it reads invalid column value

Paul Newcome

To pull the date/timestamp into a text/number type column, try this...

=Modified1 + ""

Andrée Starå

@Jonathan Martinez

Happy to help!

To show the information in another cell that you can add +"" after the formula.

Did that work/help?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Jonathan Martinez

Thank yall @Andrée Starå and @Paul Newcome

Paul Newcome

Happy to help. 👍️

Andrée Starå

@Jonathan Martinez

You're more than welcome!