Bid Levelling

PeggyLang

I need to create a solution to analyze bids received and award a contract. I'm hoping this is possible through Smartsheet, however, have not yet been able to cobble together a solution.

I have 3 separate worksheets titled 'GC #1 Bid', 'GC #2 Bid', 'GC #3 Bid'.

Ideally I would like to have 1 worksheet with each bid in separate columns;

Any thoughts on how I might accomplish this in a fairly automated manner? I realize that I could 'copy' each column from the individual sheets and paste into the 'Bid Levelling' sheet, however I anticipate having many situations for different team members where this action will be wanted.

Andrée Starå

@PeggyLang

You'd create a templatized solution that you can use and save as new each time and it would already be connected.

Make sense?

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Darren Mullen

@PeggyLang What do the other 3 sheets look like? Do they look the same and you want to pull in the values row for row?

Andrée Starå

Hi @PeggyLang

I hope you're well and safe!

Many years ago, I helped a client with something similar, and then I created a results sheet by cell-linking each bid's answers to it and then added formulas/reports to compare them.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PeggyLang

@Darren Mullen The 3 'GC Bid sheets' look exactly the same only with 1 column for their individual bid.

@Andrée Starå This solution would be used over and over again by our team.

I thought I could use DataMesh, however, DataMesh goes across the sheet (left to right) whereas I need data from one entire column ('GC #1 Bid) to populate top to bottom and then 'GC #2 Bid to populate in the next column all the way down.

How would I automate creating the 'cell links'?

Andrée Starå

@PeggyLang

You'd create a templatized solution that you can use and save as new each time and it would already be connected.

Make sense?

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

PeggyLang

@Andrée Starå THANK YOU! I used an Index/Match formula WORKED PERFECTLY!!!

LOVE this community.

Andrée Starå

@PeggyLang

Excellent!

You're more than welcome!