Power Query removes formulas from custom columns on refresh

[One Handed]

Hi,

We have an outdated database for tracking enquiries. We are trying to create a spreadsheet that pulls data from the database and also allows us to add additional information by adding extra columns.

I have created a "self-referencing" table in excel to allow this. Manually added data to the custom columns works great.


The problem I am having is with the columns which contain formulas. When PQ refreshes the formulas are deleted.
Worth noting, if the formula has produced data, the data is retained but becomes static data (the formula behind that cell is gone).

e.g. A new column we added is [Follow up reminder date], which uses this formula
= IF([@[Date Information Request Sent]]="","",WORKDAY([@[Date Information Request Sent]],10))

So if [Date Information Request Sent] is filled in, then the formula will generate a date for the [Follow up reminder date] column. The newly calculated date will stay after a refresh, but the formula behind it is gone. For the rows in which [Date Information Request Sent] is blank, the corresponding row in [Follow up reminder date] is now blank and the formula is gone.



Does anyone have any suggestions on how to get around this issue? Please let me know if you need further information to assist with troubleshooting.


Many thanks in advance!!!