Question for GoogleSheets Wizards

Webmaster Discussion
#1

I have a spreadsheet where I keep track of scenes issued by sponsors. I have a field where I enter the date I grabbed the scene and another field where I enter the scene title.

I’m wondering if it’s possible with some wizardry to get the cell with the date to change to today’s date when I change the title in the title field today.

#2

I think this will be very useful for your purpose.

1 Like
#3

Try this =IF(COUNTBLANK(A2)=0, TODAY(), A1) (where A1 is the date field and A2 is the title field)

1 Like
#4

Thanks to you both. I know very little about Google Sheets, so didn’t even know what to search. I appreciate your help.