Formula that needs to reference multiple columns

BESP10 ✭✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

Good evening, 

We are looking of how we would structure a formula to calculate the % of our production job each series is responsible for.

  • There are 6 series (sequences) in this job. 1 thru 6. In the "Series ID" column. There are 300 rows +/- that make up the 6 series
  • The 6 series make up 100% of the job as calculated in the "% of Total Production Time"  column
  • what formula would I use to calculate what % of the job Series 1, 2, 3 is etc ?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!