Skip to main content

Add wastage to the business sheet

Add wastage formulas to business sheet by day of week.

Written by Jon Lee

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?