- Thank you received: 0
 
copying formulas to another class
- gkitchner
 - 
				
				
				                    Topic Author
								             - Offline
 
		Less
        More
        
            
    
        
			
    
						8 years 3 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
 
			
    
						8 years 3 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 10 months 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.