I have a sheet created in which specific employees are awarded bonuses on. Those marked as completed would receive a bonus. So I need the formula for Status, assigned, Job # and address


Best Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭
    Answer ✓

    It sounds like a report would be more appropriate to your use case than adding formulas to your sheet. You can set up a report referencing this sheet, filter it to only include completed jobs, and then group it by either address or person depending on how you want to use the data.

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    If you needed to chart it based on that particular breakdown (name and location), you would need to use a COUNTIFS in a sheet. Report groupings can't be used for stacked column charts.

    =COUNTIFS({Location}, @cell = Location@row, {Name}, @cell = Name@row, {Date}, AND(IFERROR(MONTH(@cell), 0) = MONTH(TODAY()), IFERROR(YEAR(@cell), 0) = YEAR(TODAY())))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!