Project scheduling - moving from Excel

edited 12/09/19 in Formulas and Functions

We currently use Excel but want to move our Scheduling spreadsheet to Smartsheet.

Here are some details:

  • We have 8 employees that can weld.
  • Some of the 8 can work on small parts, some can work on large parts, and some can work both.
  • Our Sales Orders may contain small parts, large parts or both. We list how much time for each and use in formulas to determine if we are over-scheduling based on ship date.
  • We plan weeks and months ahead.

    We don't assign welders to orders, but tally up how many hours are available vs what is due that week. For example:

    -we have 14 welders hours available for small parts and need 10 hours. Therefore, we have an extra 4 hours available.

    -we have 42 welders hours available for large parts, but need 50 hours. Therefore, we are short 8 hours.

We currently have formulas that total the hours up and compare them. Using conditional formatting, if the hours available are lower than the hours needed, the cell will turn red. (see screen shot) 

I'm trying to figure out a way to import this into Smartsheet. Any ideas on the best way to do this? Right now we are doing a lot of manual entry.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!