Need help with a formula

Hi,

I hope all is well and I was wondering if you anyone can help me with a formula.

On my Monday.com board I currently have three columns:

Hrs Completed So Far
Scheduled Hrs to Date
Owed Hrs

Here are three examples of the data that would be in this fields:

Example 1:
Hrs Completed So Far: 161 Hours
Scheduled Hrs to Date: 135 Hours
Owed Hrs: -26 Hours

Example 2:
Hrs Completed So Far: 64 Hours
Scheduled Hrs to Date: 72 Hours
Owed Hrs: 8 Hours

Example 3:
Hrs Completed So Far: 72 Hours
Scheduled Hrs to Date: 72 Hours
Owed Hrs: 0 Hours

In the three examples listed above I have three project which is under, over or exact in hours.

The Owed Hrs column is a formula which has the following formula:

{Scheduled Hrs to Date}-{Hrs Completed So Far}

I am looking to refine this formula and In need of some help. Ideally, I would like the formula to output the following scenario:

If the Hrs Completed So Far is over the Scheduled Hrs to Date I would like it to simply report back as “Not owed any hours” rather than the negative number (as shown in example #1). However, if the hours are exact or under then to simply report the hours (as shown in example #2 and #3).

I did attempt the formula myself but I am receiving an incorrect formula notice:

IF(
{Hrs Completed So Far}>{Scheduled Hrs to Date},
“Not owed any hours”,
IF(
{Hrs Completed So Far}=<{Scheduled Hrs to Date},
{Scheduled Hrs to Date}-{Hrs Completed So Far}
)
)

Your help will be greatly appreciated.

Thanks

Hi @anthonywoods,

Try:

IF({Hrs Completed So Far}>{Scheduled Hrs to Date},"Not owed any hours",
{Scheduled Hrs to Date}-{Hrs Completed So Far})
1 Like

Hi @GCavin,

Thank you so much for your input and help.

Your formula tweak helped to resolve my problem.

All the best!