Skip to main content

Add wastage to the business sheet

Add wastage formulas to business sheet by day of week.

Jon Lee avatar
Written by Jon Lee
Updated over 2 months ago

To display wastage figures on your business sheet, use the formula =wasteval(x,0), where x represents the day of the week:

  • 1,0 = Monday.

  • 2,0 = Tuesday.

  • 3,0 = Wednesday.

  • 4,0 = Thursday.

  • 5,0 = Friday.

  • 6,0 = Saturday.

  • 7,0 = Sunday.

  • 0,0 = Total for the week.

Update the first value in the formula to match the desired day, and the corresponding wastage will be reported accordingly.

πŸ€“ Tip: Check how to make changes to your business sheet here.

Did this answer your question?