Project Tracker

Erica C

I'm new to smartsheets. We currently use it in several different areas of my current project for some basic entry stuff pertaining to my projects. I have the field supervisors entering their production for that day/week with all the sites they work on. I have another sheet that I have my list of 53 job sites & where they are; from engineering to billing the customer. I track my 53 jobs sites in an excel spreadsheet and I'm wondering if Smartsheet has the capability to track as my excel does but better & linking what my field puts into production & my project tracker.

I'll try my best to explain how my spreadsheet works in words. I'm a numbers person, not a good writer :)

In my excel, the first tab is the list of all the jobs, as they come out of engineering I'll add a new tab with the name of the jobsite, cost, revenue, sub pricing basically breaking down the entire job. Once the field starts the job, they'll put in their production into the smartsheets & I'll enter that information into my excel spreadsheet, letting me know exactly how much we have left, if we're going over, if the sub has gone over, if we need a change order, etc. All while this is happening, my main page is linked to the tabs so when I have my weekly meeting with my upper management they can ask specifics about any job by looking at the spreadsheet. For example, if we're over it on a job even by 1%, the cell changes colors, alerting myself & everyone on my team. Further down the sheet I also have a column that shows any outstanding cost we owe the subs or if we over paid them by the PO amount I've added into each individual tab.

I want to work more in smartsheets, have a dashboard for my stakeholders, have one stop place for my production being entered from the field, and a place for me to track my projects as I have on excel. Is there anything remotely similar in smartsheets to what I have now in excel?

Paul Newcome

This is all very possible, but definitely a bit more complex than what can be explained in a Community post. Take a look through the templates in the Solution Center to see what is out there for project and portfolio management. It also sounds like the premium add-on Control Center would be great for this as well.

If you are still needing help, you can also search for a certified Smartsheet Partner (link below) to help with builds.

https://www.smartsheet.com/marketplace/partners#numberOfResults=25&f:@type=%5Bdeveloper%5D&f:@language=%5BEnglish,German,Japanese,Spanish,French,Russian,Italian,Portuguese,Polish%5D