Help with an inventory tracking formula

steve50951

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

sean59916

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

 

 

 

 

Andrée Starå

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

steve50951

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

Andrée Starå

Happy to help!

Pro tip. Add a unique character at the beginning of the formula in excel, and then you can activate it in Smartsheet with search and replace.

Hope that helps!

Best,

Andrée

sean59916

Thanks for correcting Andrée, I misread the request. Cheers.

Andrée Starå

You're welcome, Sean!

We've all done it! Next time you'll correct me!

Best,

Andrée

Paul Newcome

This right here... ^^

 

Great tip!!