A number minus 0 is showing negative

Options

Hello, I have a group of people who have a certain number of hours to complete a project. When they have yet to log time against that project, the logged time column is showing 0. Then, my formula finding the sum of the number of hours allotted (5 for example) minus the number of hours logged (0 for example) is showing as negative (-5). But I need it to be just 5. How can I fix this?

Here is my formula: =SUM([Actual PCD Touch Time Logged Active Projects]@row - [Hours in Funnel with CDR Due Date]@row)

Many thanks in advance!

Best Answer

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Answer ✓
    Options

    Which column indicates the actual logged hours and which indicates the allotted hours. Just based on the column names it appears they are backwards and should be

    =SUM([Hours in Funnel with CDR Due Date]@row-[Actual PCD Touch Time logged Active Projects]@row)

Answers

  • Hollie Green
    Hollie Green ✭✭✭✭✭✭
    Answer ✓
    Options

    Which column indicates the actual logged hours and which indicates the allotted hours. Just based on the column names it appears they are backwards and should be

    =SUM([Hours in Funnel with CDR Due Date]@row-[Actual PCD Touch Time logged Active Projects]@row)

  • BFuller
    BFuller ✭✭✭
    Options

    yes, that was it. Goodness…I am just so hyper-focused on this that I can't see the forest through the trees! Thank you so much!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!