How to Capture 1st Child to Change?

How to Capture 1st Child to Change?

I have child rows that will change status colors. Once it changes, it remains that color. I'd like to find out which child changed first. Is there a way to do that?

Thank you



Best Answer

Answers

  • Hi @SYSPK

    You could check the Cell History manually for any of the updated cells to compare dates for when the change was made, but currently there is no way to return that cell history in the actual grid of the sheet (please submit an Enhancement Request for this!).

    Another option would be to put a Modified Date system column in your sheet, if no other changes will happen for the row after the status shifts. Then with that Modified date, you could have a formula point out which one changed first... but again, this would only work if the status was the only element changing for those rows. Modified Date columns will update as soon as any modification was made to the row.

    Or, there may be a different way to do this using a third party tool like Zapier.

  • Thank you @Andrée Starå that works! It's a lot of work to set up but will give the results.

  • Andrée StaråAndrée Starå ✭✭✭✭✭

    @SYSPK

    Excellent!

    You're more than welcome!

    Yes, it's a little work, but depending on other workflows, you could reuse it for them.

    Remember! Did my post(s) 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!

    Best,

    Andrée Starå

    Workflow Consultant / CEO @ WORK BOLD

Sign In or Register to comment.