Summing FTE Hours available in the future

I am currently utilizing the current formula =SUMIF({Resource name}, [Resource Name]@row, {Weekly Scheduled Hours}) to determine how many hours a resource has available. Since I began using this, some assignments have ended, but resource utilization is still being summed, resulting in weekly hours scheduled being >40. How do I tweak this formula in order to determine CURRENT resource hours scheduled?

I think I need to tweak it to be a SUMIFS formula pulling in Assignment end dates and indicating greater than TODAY? I.e. something like this: =SUMIFS({Resource Name}, [Resource Name]@row, {Weekly Scheduled Hours}, {Assignment End Date}, >TODAY)

However, this formula returns #UNPARSEABLE

Any insight on what I'm missing?


Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!