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

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

Find more posts tagged with

Forms

Sales

Templates

Sheets

Conditional Formatting

Importing and Exporting

Cell linking

Comments

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.

Sign in to join the conversation!

Quick Links

Trending discussions

Monthly feedback from multiple individuals
Hello community, I need help figuring out how to set up a sheet to collect monthly comments on several projects. Each project is assigned to a different person who need to provide monthly feedback on its progress. Ideally, I would like them to receive a reminder notification on the report due date, followed by reminders if…
Sheet shows BLANK rows, there is a "MOVE rows" worflow, is that why?
Is it possible that a workflow that MOVES rows to another sheet too basically do a CUT/PASTE (like in Excel), and then you are left with BLANK rows on your original sheet? I cannot think of any other LOGICAL reason why this would happen. The users enter the data from an Intake Form, it gets placed onto this sheet. They do…
Sorting not working?
Hi. I have a sheet where I am sorting dates by ascending order. But the sorting functionality doesn't seem to be working. Instead of bringing all items with date values to the top of the sheeting and sorting them in ascending order, it leaves a gap. Is it a result of the "Next Review Due" column containing a column formula…