How do I import a MSProjoject into SS reflecting the benchmark details

Venn Cannon

I have a client who is heavily invested into MS Projects, his template reflects his benchmarked dates as well as the actual start and end dates, when I import the project plan it does not reflect the benchmarked dates although I can view them in the original MS Project file. How do I get all this data in, please help, at my wits end, and really don't feel like going back to MS Projects.

Cheers Venn

Genevieve P.

Hi @Venn Cannon

It sounds like you may want to create a Baseline in your Smartsheet Sheet (here's a free webinar that goes over Baselines: Keep Your Projects on Track with Baselines).

What I would do is copy/paste in the Start and End dates for your baseline/benchmarks first, set the Baseline in Smartsheet, then copy/paste in the actual Start and End dates, which will update the Variance in the Baseline. See: Set Baselines on a Project Sheet

Cheers,

Genevieve