Hardcode excel formula in studio did not working

[farrissya.z]

Good day. I have a question. I want to hardcode the excel formula for day differences of current date and a date column. The problem is, it just put the formula in and I need to press enter manually in excel to get the result.

[Yoichi]

HI,

Do you write these data using WriteRange activity?

If so, I think "[k(tab)]" is unnecessary. Can you try to remove it?

Regards,

[lrtetala (Lakshman Reddy)]

Hi @farrissya.z

Use Write Cell activity

[farrissya.z]

im using append. i did removed the [ktab] but still the same

[Yoichi]

HI,

Can you share screenshot of the cell when removed [k(tab)]?

Regards,

[farrissya.z]

Here it is

[farrissya.z]

It’s worked. thank you!