Forum Discussion

JosieGarbutt's avatar
JosieGarbutt
Copper Contributor
Feb 14, 2023

Spreadsheet Help!

Hi There!

 

Hoping someone might be able to assist.

 

I am doing up a food costing spreadsheet and am using a pre-designed spreadsheet.  Only some of the formulas are drawing through and I can't see where to adjust it to make the information pull through.

 

this is the formula - =IFERROR([@[Standard_UnitCost]]/[@[Standard_Qty]],"") and it draws the info through for some of the items but not all.

 

 

  • JosieGarbutt 

    You are working with Excel Table, formula is applied to each row of the table with automatic expansion. However, if you enter something else in any cell of this column that won't work.

    As HansVogelaar mentioned it's better to discuss with sample file.

  • JosieGarbutt 

    Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

Resources