- Thank you received: 0
copying formulas to another class
- gkitchner
- Topic Author
- Offline
Less
More
7 years 4 months ago #6987
by gkitchner
copying formulas to another class was created by gkitchner
Hi all
Anyone got the clue for copying a formula that has been created in a column of one class to a different class. Can't seem to activate copy function when in the formula, also tried copying column with formula to another class but does not seem to take the formula with it - any ideas please.
Just started using formulas and functions - isn't idoceo the best thing that has happened in teaching - that and google classroom.
Greg
Anyone got the clue for copying a formula that has been created in a column of one class to a different class. Can't seem to activate copy function when in the formula, also tried copying column with formula to another class but does not seem to take the formula with it - any ideas please.
Just started using formulas and functions - isn't idoceo the best thing that has happened in teaching - that and google classroom.
Greg
- bert
- Offline
Less
More
- Thank you received: 749
7 years 4 months ago #6988
by bert
Replied by bert on topic copying formulas to another class
Hello Greg,
Formulas can't be copied individually because the columns they are referring to do not exist in the target class.
Here is a couple of alternatives:
If you copy the whole tab, formulas will transfer: long tab on tab > copy
If you select all columns involved in the formula + formula and copy it should work as well:tools > columns > select your columns > copy
If the formula belongs to a category and alll required columns are inside the category, copying it to another class will keep everything intact: long tap
on category header > copy
Formulas can't be copied individually because the columns they are referring to do not exist in the target class.
Here is a couple of alternatives:
If you copy the whole tab, formulas will transfer: long tab on tab > copy
If you select all columns involved in the formula + formula and copy it should work as well:tools > columns > select your columns > copy
If the formula belongs to a category and alll required columns are inside the category, copying it to another class will keep everything intact: long tap
on category header > copy
- ajacksonjr52
- Offline
Less
More
- Thank you received: 0
2 years 2 weeks ago #30726
by ajacksonjr52
Replied by ajacksonjr52 on topic copying formulas to another class
Actually, you can copy the created formula. On the iPad, once the formula is created, press in a blank area, and the copy/paste option should pop up. Click copy and then paste the formula into the other column on the next tab. You will have to change the variables. On each tab, my classes have the same column but it must match the one on that tab. After you copy the formula, then you will have to create a formula column and add paste the formula inside the box.