I have a series of standard processes that have the same dependency and predecessor data each time. 

I have the primary column  as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.).

If pre-assembly is selected, for




Need some help with a formula, I am trying to add two columns that meet the same criteria from one sheet to total on another sheet. 

I have tried Sumif and sumifs formulas but they both comeback with errors

Here is what I need:

On sheet 1 I want to total columnA and columnB on sheet two if


I have created a smartsheet that contains a form for my team to fill out. Once this form is filled out I would like that data to go to the main sheet that is viewable by my team and then populate another sheet that is viewable to the managers only. Is there a way to have that data when added to


I have created extensive data matrix's to calculate # of Jobs and dollar amount for individuals in our company to track capacity. However, as our sheets get larger, the formulas wont calculate. I receive an error message reading:

"Some cross-sheet formulas cant be updated, because this sheet has