Add Date in Column A1 without the formula actually being in A1

[Lawfull]

This is a tricky one. I use Zapier (API) to automatically add new client info from our CRM into an existing Google Sheet. When it does it adds the info into the next blank row to columns, B, C, D, & E, leaving A blank because I have a formula in all rows in column A to add the date in column A when texts is added to column B. IE:

=IF(B1<>"",IF(A1<>"",A1,TODAY()),"")

However, I found that although Zapier is supposed to leave A blank for the date created formula it still over rights all the data in that row, including the date formula in column A.

Is there a way to add a formula in any other cells to change the date in A1 when data is entered into B1 without the formula actually being in A1?

Suggestions?

[AliGW]

No, it’s not possible without VBA.

You had help in your first thread - you probably need to go back and say thanks: https://www.excelforum.com/excel-gen...-into-one.html

[Lawfull]

That's kinda what I thought. Thanks for the reply, Ali.

[AliGW]

Shall I move this to the VBA section?