Forum Discussion
JosieGarbutt
Feb 14, 2023Copper Contributor
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.
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.
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?