Isolating Reports & Linking from sheet to sheet

06/28/19 Edited 12/09/19

We have a data base of Subcontractors, that is created in a sheet.  I am trying to have a tracking sheet (Bid/Contract Request) from bidding to contracts per job and per subcontractor.  I have a column of subs that I have linked from the data base and then a column (checkbox) per job.  Then the superintendents will go to this sheet and checkbox who they need a bid request sent out too. So from there I tried to have a report pull the subs that would work that job and have report per job, so that per job we could track the bidding --> contract process.  Not sure which direction to go next. I have created a couple of different ways to do this. However both are having issues that I can' figure out.

As we were check marking the progress on the job report, it was sending it back to the Bid/Contract Request sheet. From there it was bleeding over to other job reports. Is there a place that I can turn it off so that each report is isolated and does not pass info onto other reports? So far trying this out, selections (or checked boxes) are transferring to other reports. This makes it not very accurate.

I also made an individual sheet per job. I linked the data base to these sheets, and I have tried it out and it shows if I add a new Subcontractor to our data base, it will not transfer (or forward ) that information to the Bid/Contract sheet. Maybe I am missing something, could someone point me in the direction or give me a step by step so that I can double check my linking skills.

Thank you all for your help on these questions.





  • Andrée StaråAndrée Starå ✭✭✭✭✭

    Hi Kim,

    Can you maybe share some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help.

    Have a fantastic weekend!


    Andrée Starå

    Workflow Consultant @ Get Done Consulting


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

    W: | E: [email protected] | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me about help with Smartsheet, integrations, general workflow advice, or something else entirely.

Sign In or Register to comment.