Veronica J’s Profile

Community member since January 2019

American Electric Power


Good Morning,

I am struggling with the SUMIFS function. I have a sheet that contains job orders. The job orders have a planned start date. The jobs are also categorized by Job Type. I have the following columns:

Job Type

Planned Start

JSH *job site hours*

What I need is to calculate the sum of total



I have the following project I would like to achieve in Smartsheet if possible. I have a master data sheet with information hard coded. The sheet has a key reference number associated with each assigned task. When a user wants to add a task into the master sheet, they have to open the form