How do I copy value from several column into another?

Question

Hi, can anybody help, Im trying to create a datasheet, that has countries as columns, so when you choose a country you can only see a choice of facility in that country. then at the end, I want what ever I choose as a value be reflected in another row that is meant to show my selected facility form any country.

my problem is when I use the "=", then "+" all columns, the first few columns are returned correct, but as i go to other column, the return has a Zero before the facility ID… is there a better way to not have that zero.

MarceHolzhauzen · Accepted Answer

Hi @Noel Odalager

From your question, I am understanding that you want a blank cell instead of a "0".

If so, there are a couple of ways to do this.

1. You can use an =if( (current formula) = 0,"", current formula). Where current formula is what you have in the cell at the moment. The "" part will be what in essence removes the 0

2. Depending on the number of columns you have, you could make use of the isblank formula to.

Let me know if you would like to have a quick chat about this, or just schedule a session in my calendar here → Check my availability