Formula Sumif Range w. Web Form

Nicole Hanik
Nicole Hanik ✭✭
edited 12/09/19 in Formulas and Functions

I have a sheet where I am using a Webform to gather data.  Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries.

=SUMIF(Task2:Task4, Task5, Hours2:Hours4)

New Webform entry is line 5, Formula will not automatically capture that added line. 

Please help.  

Objective is that based on the task name to obtain a total number of hours worked (in a massive list of data)  - that is then linked back to a project summary as a total hours worked cell.  


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!