Alert for Filling in Cell for First Time?

SYSPK

Is there a way to be alerted when a cell goes from Blank --> not blank? To see when it got edited for the first time?

To be alerted when any change is made in that cell doesn't help me.

 

 

Andrée Starå

Hi,

I'm thinking that it could maybe work with a helper checkbox column and something like this.

=IF(NOT(ISBLANK(A@row)); 1; 0)

The same version but with the below changes for your and others convenience.

=IF(NOT(ISBLANK(A@row)), 1, 0)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Would that work?

I hope that helps!

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

 

SYSPK

Yes it does!

Thanks

Andrée Starå

Excellent!

Happy to help!