Value in one sheet create a "populate" trigger in another sheet

BESP10

Good afternoon

We have a bid invite sheet that we fill out with prospective jobs (each row is a prospective job) to bid on. It has multiple columns of Data that if we decide to bid on the job would need to be transferred to our sales/estimating sheet. 

 

If we had a YES/No drop down column and we choose YES is there a way to have that row transferred to the new sheet?

 

Thanks

Andrée Starå

Hi,

Yes, almost certainly but it depends on the specifics. There are a few ways to set it up. Cell linking, cross sheet formulas and more.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (share too, andree@getdone.se)

Hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Stuart.d

Hi, 



We have something similar just a little less automated, we have several columns as checkboxes, these are all linked to conditional formatting- highlighting the full row, different colours relate to different outcomes. 



We then right click the row number and select "Move to another sheet" subject to our chosen outcome, for example we have Project complete (which moves to an archive), Snagging (which moves to a defects sheet), In Production (Moves onto the Production schedule) etc



This could be a simple option for you? 



Regards 

Stuart

Jacques@SBP

We have a solution that does exactly this.  It is an API based solution and is fully automated. It uses a simple criteria of a column value to trigger the move.  Let me know if you want to know more

thank you

jacques @ smarterbusinesprocesses

Pam Grant

Smartsheet has an automation, now, for moving rows based on a trigger. (eg. when the Yes/No column changes to "Yes")

The names for each column on the bid sheet and sales/estimating sheet need to match but they don't have to be in the same order.

Note: if you have columns on the bid sheet that are not on the sales/estimating sheet, they will be added to the far right end of the sales/estimating sheet when the row is moved over.