Update status in another smartsheet

SueinSpain

I have an asset register, each with a unique asset number that also holds a status (In service, out for repair, decommissioned)

I also have an asset damages log where an asset is reported as faulty or damaged and is sent for repair. If unrepairable it will then be decommissioned.

My question is....... how to I update my asset register if I receive a damage log for that asset, to change the status to "Out for Repair" and then when the repair it completed change it back to "In Service"

Any ideas anyone as I just cannot come up with a workable HOW to do this :)

Many thanks

Sue

SueinSpain

UPDATE: Index / match / collect is awesome for accessing a lookup type table in smartsheet and I've started using but have just revolutionised my life by getting Data Shuttle.

Oh my goodness I can import on a schedule from an extract from our core SAP system and update my lookup type tables.

I can extract from one smartsheet to then imput into another preventing the need and risk of double keying

I'm about to learn how to update dropdown menus too

Only just over a week into the training and support and absolute game changer for us to also be able to export from smartsheet into a error or incident handling system.

Wow my life just got a whole lot busier

Itai Perez

Hi @SueinSpain

Can you share some screenshots to help us understand a bit better?

SueinSpain

Here is the aset register showing the TMS units and it is the first one I am interested in. It is In Service as being used as far as I know.

Now I have just received a damage log to say this asset has been damaged and is being sent in for repair - the depot and asset number & asset type are the same.

My question is....... is there any way to update/change the Status field in the top smartsheet from In Service to equal Out for Repair and this would be triggered by the row being added to the bottom smartsheet.

Hope this makes sense :)

Sue

Andrée Starå

Hi @SueinSpain

I hope you're well and safe!

Yes, you could add a cross-sheet formula INDEX/MATCH and collect the status, and either shows that in the same column or a so-called helper column or/and a workflow triggered multiple times a day changing the status.

Make sense?

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!

SueinSpain

UPDATE: Index / match / collect is awesome for accessing a lookup type table in smartsheet and I've started using but have just revolutionised my life by getting Data Shuttle.

Oh my goodness I can import on a schedule from an extract from our core SAP system and update my lookup type tables.

I can extract from one smartsheet to then imput into another preventing the need and risk of double keying

I'm about to learn how to update dropdown menus too

Only just over a week into the training and support and absolute game changer for us to also be able to export from smartsheet into a error or incident handling system.

Wow my life just got a whole lot busier