Skip to main content

How does it work?

You can use the custom workday parameter in the Advanced formula editor to create a formula that shows different static numbers on different days.

In this case, the formula would not reflect the working days, but it would use the parameter to tell Plecto what values it should display on what days.

A quick refresher on how the workday parameter works

The parameter is binary (it consists of 0's and 1's) where

0 represents a workday AND
1 represents a day free from work.

The parameter requires a total of 7 digits, one digit per weekday. The typing order in the formula goes from Monday to Sunday.

Formula example

Say you want the widget to show 555 from Monday to Thursday and 80 from Friday to Sunday.

  1. Go to Formulas > New formula.

  2. In the top-right corner, click Switch to advanced editor.

  3. Copy the following formula and paste it into the editor. (IF(NetWorkDays(StartDate(),EndDate(),1111000)>0,80,555))

  4. Keep the number formatting to Decimal number.

  5. Click Save in the bottom-right.