Join 3,414 readers in helping fund MetaFilter (Hide)

4 posts tagged with spreadsheets and Spreadsheet. (View popular tags)
Displaying 1 through 4 of 4. Subscribe:

Getting Google Spreadsheets to interpret string as formula

I have hundreds of text strings entered through a form in a Google Spreadsheets which look like 4*3 9*2 17*3 22 37*4 52. I can easily substitute " " for "+" and concatenate a "=" in front =4*3+9*2+17*3+22+37*4+52. Now I have a text string which looks like a formula but isn't one. How can I make Google Spreadsheets interpret this string as a formula? [more inside]
posted by Akeem on Mar 12, 2009 - 3 answers

Compare and output greater value.

Spreadsheet question: Display Greater Value? I know this is one of those "you-either-know-it-or-you-don't" situations, and I just don't know. [more inside]
posted by guptaxpn on Feb 5, 2009 - 6 answers

iRows shutting down. How do I share my spreadsheets now?

Well, the people at iRows are shutting down their service at the end of the year and I need to find a way to share my spreadsheets with other people. As usual, there are some problems [more inside]
posted by killa62 on Nov 15, 2006 - 8 answers

Excel Spreadsheet Updating

Excel query. I have two Excel spreadsheets that I want to have automativally update each other. But, the format that they are in is generally incompatible. These are used as scheduling documents for the place where I work.

One spreadsheet is very wide. It lists each individual person at the top and their personal schedule below it. It lists breaks using "ONE" as the first half of a 30 minute block, "TWO" as the second half of a 30 minute block, and "LONG" as the entire 30 minute block.

The other spreadsheet is much less wide. It has 7 days listed and three columns. One is for "LONG" one is for "ONE" and the third is for "TWO." In each column, each person's name is entered in the appropriate block as defined in the first spreadsheet.

Can I get those two to talk to each other? Can I tell the first spreadsheet that if the word "TWO" is in a certain field to put the name of that person in another field on another spreadsheet?
posted by ajpresto on May 11, 2004 - 1 answer

Page: 1