Hi Please tell me this isn't possible if so. I have a google sheets that has check boxes (D3) which require a date in cell next to it (E3) and I would like to take out formatting issues by using a formula to input the date I have managed to get =if(D5=true,TODAY(), "") to work but this just shows the date if i put =if(D5=true,NOW(), "") also works but as i have more than one tick box it refreshes to that new tick moment. any thoughts would be appriciated Regards Matthew (Keyboard muppet)

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

google sheets time/date stamp query

Thread starter Mattlake
Start date Jan 26, 2024
Tags

formula googlesheets

Mattlake

Board Regular

Jan 26, 2024

Hi

Please tell me this isn't possible if so.

I have a google sheets that has check boxes (D3) which require a date in cell next to it (E3) and I would like to take out formatting issues by using a formula to input the date

I have managed to get

Excel Formula:

=if(D5=true,TODAY(), "")

to work but this just shows the date if i put

Excel Formula:

=if(D5=true,NOW(), "")

also works but as i have more than one tick box it refreshes to that new tick moment.

any thoughts would be appriciated
Regards
Matthew
(Keyboard muppet)