Last modified for specific cell

Jivi3

Hi!

I am trying to figure out if there is a formula to basically look at a cell and see when a specific cell is modified. I am trying to use this for KPIs.

For background:

I have a workflow where if something is rejected by my engineering department the person who created the request is then triggered to answer engineering's specific reason for rejection. I need to basically know the date that engineering created the rejection, and the date that the rejection was clarifying information was responded to by the non-engineering individual. Is there a way to do this?

Genevieve P.

Hey @Jivi3

You can use a Record a Date action block in a Workflow to add a date to a column in your sheet when something specific changes. It sounds like you'll want to add that to your Update Request workflow. Here's more information: Set the current date with the Record a Date action

Cheers,

Genevieve

Genevieve P.

Hey @Jivi3

You can use a Record a Date action block in a Workflow to add a date to a column in your sheet when something specific changes. It sounds like you'll want to add that to your Update Request workflow. Here's more information: Set the current date with the Record a Date action

Cheers,

Genevieve

Jivi3

This worked great!!! Thank you!