Monitoring Workload without Resource Add-On

edited 01/27/23 in Formulas and Functions


I am managing a project in Smartsheet where I need the ability to conduct ongoing monitoring of resource hours for tasks per week. The use case is for the PM to use this info to ensure the estimated times of tasks assigned to a given individual don't exceed that person's availability cap (That data is stored elsewhere, so it would be a manual comparison of external data vs. the sum of estimated hours for that week). Our org has enterprise, but unfortunately we don't have the resource management add-on. Without that, is there an intuitive or workaround method to pull weekly estimated hours for assignees? Ideally the time window view would be flexible to a 2 or 4 week view in weekly increments. Thanks in advance for any guidance provided.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!