I am recording patients contact in the app. I would like to gather as much info as possible but: - I am arranging the columns of the google sheet according to the order of the questions/information i want in the app - but i would like to set the rules to have a particular questions/info disappearing in case the camp is blank. For example:
if i fill telephone 1, i would like to have the option to add a telephone 2, once telephone 2 is added, i would like to have the option to add a telephone 3 and so on.
In case i don’ t have a telephone 4 to add to the patient - how can i make it disappearing from the information of the patient? (as per the picture?) At the moment, i am using the following formula: on Telephone 4 i have: SHOW IF:=ISNOTBLANK([Telephone 3]) By doing that though, once I go inside the patient info, I have a blank space for Telephone 4, would it be possible to take it out with any formula?
Thanks so much