I am working in google docs, in the spreadsheets section trying to figure out some custom functions. Working with text and numbers.
what i am wanting to do:
Code:
what i have right now
Code:
it is throwing a formula parse error.
The count blank part i found online, because i was unable to find a function that did quite what i wanted it too, and i thought that would work.
each of the rows i am sorting has one of 5 groups, i was wondering if i could then sort these by their group to make it easier to copy and paste them as a bunch and send there where they need to go.
example Group 1:
all the group 1 rows. as a single string after the concat.
Group 2:
all the group 2 rows.
its fine if they have to be in a different spot of the concat. (which i think they would have to be.
EDIT: Question was resolved by a friend that is a pro on google docs, he just wasnt on at the time of this post.
if anyone was curious on the code that replaced mine.
Code:
much easier than what i was doing.
what i am wanting to do:
Code:
if (Cell:cell) = blank
Then
concat(a5,b5,c5 etc)
else
leave cell blank
what i have right now
Code:
=IF(COUNTBLANK(F5)=1;"Blank cell";"Not blank") TO_TEXT(A5) CONCATENATE(A5,B5,A3,F5,D5)
it is throwing a formula parse error.
The count blank part i found online, because i was unable to find a function that did quite what i wanted it too, and i thought that would work.
each of the rows i am sorting has one of 5 groups, i was wondering if i could then sort these by their group to make it easier to copy and paste them as a bunch and send there where they need to go.
example Group 1:
all the group 1 rows. as a single string after the concat.
Group 2:
all the group 2 rows.
its fine if they have to be in a different spot of the concat. (which i think they would have to be.
EDIT: Question was resolved by a friend that is a pro on google docs, he just wasnt on at the time of this post.
if anyone was curious on the code that replaced mine.
Code:
=if(F5="","",CONCATENATE(A5," ",B5," ",A$3," ",F5," ",D5))
much easier than what i was doing.