Hey APPSHEET,
I am a new User.
I want to continuosly append text everytime a value is changed in a specific cell without deleting its previous content.
for example,
i have a column named “LATEST SPO2” containing data like this “94% at 11pm” and the other column named "HISTORY " saving the data.now my demand is to store the value of “LATEST SPO2” as past record in “HISTORY” every time value of “LATEST SPO2” is changed…suppose value of “LATEST SPO2” changes now from “94% at 11pm” to “90% at 12pm”, i want to display only “90% at 12pm” in “LATEST SPO2” column but display as “94% at 11pm,90% at 12pm”.
Again when value of “LATEST SPO2” changes suppose to “85% at 1am” from “90% at 12pm”, “LATEST SPO2” should show “85% at 1am” but “HISTORY” should show “94% at 11pm,90% at 12pm,85% at 1am”
i hope my problem is clear…