Working with spreadsheets? Let formulas make your job done.

Well, yes and no – let me explain 😊

Yes – you search formulas by keywords, expressions, categories (job role, data type) etc. to find your use case.

But it doesn’t give you just a word to call the formula – it gives you the whole formula, ready to paste into your spreadsheet (like you would copy it from another sheet or file, it’s in your clipboard).

And it’s more about combination of functions, not just single functions.

For example, when you search “reverse name” it gives you a formula, which is a combination of functions like: LEFT(), RIGHT(), FIND().

You paste it next to the cell with your Data, e.g.: “Andrew Kamphey” and it gives you the result: “Kamphey Andrew” right away (and you can see the formula in the cell, of course).

And when you need to reverse names in, for example, the whole list of your employees, clients, leads – you just copy it to the bottom of the column and your job is done 😉

I tried to focus on use cases rather than single functions, but was also considering adding those single functions to the list before – and your comment made me think again 😊. Would you find those useful too?

And thanks for your comment Andrew!

Say something nice to sebastian_p…

2

does this translate what you're looking for into the words a formula might be called?

like "I want to add up all the numbers in a column" would be "sum()"

kamphey

·
4 years ago
·
1. 1
  
  Well, yes and no – let me explain 😊
  
  Yes – you search formulas by keywords, expressions, categories (job role, data type) etc. to find your use case.
  
  But it doesn’t give you just a word to call the formula – it gives you the whole formula, ready to paste into your spreadsheet (like you would copy it from another sheet or file, it’s in your clipboard).
  
  And it’s more about combination of functions, not just single functions.
  
  For example, when you search “reverse name” it gives you a formula, which is a combination of functions like: LEFT(), RIGHT(), FIND().
  
  You paste it next to the cell with your Data, e.g.: “Andrew Kamphey” and it gives you the result: “Kamphey Andrew” right away (and you can see the formula in the cell, of course).
  
  And when you need to reverse names in, for example, the whole list of your employees, clients, leads – you just copy it to the bottom of the column and your job is done 😉
  
  I tried to focus on use cases rather than single functions, but was also considering adding those single functions to the list before – and your comment made me think again 😊. Would you find those useful too?
  
  And thanks for your comment Andrew!
  
  sebastian_p
  
  ·
  4 years ago
  ·