Advice on a formula please

[xyzabc198]

Hi there,

Im pretty new to using formats on databases so I hope you can give me some simple advice, if it gets too tricky though I have a techy I can speak to.

Here's what I'm trying to do

In column AC I have a date column
And in AE I have a comments column

And in each row I have a company name, I enter the date I last called them in AC and what they said in AE.

I want a format that will make todays date appear in column AC every time I enter something into AE for that company...is this doable? any advice would be greatly appreciated!

~Jonathan!

 

[xyzabc198]

Sounds like you are satisfied but have you considered what should happen to col AC if:
1. A value is deleted from col AE?
2. Multiple values are deleted at once from col AE?
3. Multiple values are entered into col AE at once (eg by a copy and paste, or by entry via Ctrl+Enter)?

And I do realise btw that the link you gave me may be a little more detailed and specific, it's just the fact that I don't NEED it to do that, and would rather just leave it as it is rather than use more of the technicians time, but thanks alot for suggesting it anyway mr Peter_SSs sir :P

 

[Peter_SSs]

And I do realise btw that the link you gave me may be a little more detailed and specific, it's just the fact that I don't NEED it to do that, and would rather just leave it as it is rather than use more of the technicians time, but thanks alot for suggesting it anyway mr Peter_SSs sir :P

No problem. Cheers.