GoogleSheet IMPORTDATA with timestamp

Hi, I am trying to use IMPORTDATA in GoogleSheet with URL and TimStamp

=IMPORTDATA(https://www.amfiindia.com/spages/NAVAll.txt?t=,TEXT(NOW(),"ddmmyyyhhmmss"))


ERROR This function is not allowed to reference a cell with NOW(), RAND() or RANDBETWEEN()

It is not allowed because the prohibited functions are volatile and this will cause your data import to be constantly refreshed. I suggest you have a second cell with

Formula:

Please Login or Register  to view this content.

and a third cell where you copy and paste-values from the second cell. This third cell is what you will reference in IMPORTDATA.

@6SJ: why do you need three cells? Couldn't you have that formula in one cell and Paste Special | Values into a second? Just a thought

First cell is the one with the IMPORTDATA formula
Second cell has the TEXT(NOW) formula
Third cell has a static value copied from the second cell

Maybe I don't understand your suggestion.

No. My misunderstanding. I was just thinking about the date and forgetting the IMPORTDATA formula.