I have default data set in a cell as "Submitted" to indicate the status of a quote.
This was done using the formula =IF(S4="","Submitted") in a power query table. Then using data validation i can select won or lost as other statuses for the quote in the same column. The problem is when i refresh the table to pull in new date, the cells revert back to "submitted". How do I make the formula null once i manually change the cell data?