7

i have created a sheet that will track inventory for a given property. I am having to cut and paste information from an excel spreadsheet (from our supplier). I have some formulas built in to the sheet that will calculate if a given line item is checked off as completed.

If the information pasted into the sheet extends beyond the copied formuals, obviously the formulas dont apply the informaiton below the formulas.

Is there a way to apply the formulas to the entire column, so no matter how rows are copied into the sheet, the formulas will be applied.

I have attached a few screenshots to show how im using the formulas.

Thanks for your help.

SGF

Functionality
Formulas

Comments

SEAN WILLIAMS

Hi Steve - 

Yes, the to reference the entire column in the current sheet, use the format Column Name:Column Name for example - QTY:QTY or [QTY Arrived]:[Qty Arrived]

 

I hope that helps?

 

Sean

 

 

 

 

Hi Steve,

Unfortunately, it's not possible at the moment to have a column specific formula fill (formula would add itself always), but it's a great idea!

Please submit an Enhancement Request when you have a moment.

My suggestion would be to either fill down as far as possible in the sheet, and that would make it easier to fill the cells that are missing the formula, or if possible, you could add the formulas to the Excel before the import.

Would that work/help?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andre,

That's kinda what i thought. Just wanted to be sure I wasnt missing something that would allow me to add the entire column.

It would be a nice option. I may try the excel option in the meantime.

Thanks,

SGF

Steve