Copy cell by function

ultimatum

Hello

It's possible to execute by function to automatically copy from another sheet date to another sheet inside the specific cell when the criteria are matched?

"I want to copy from another sheet date when will be provided status of work 100% and the specific task will be done and copy to next sheet date in a specific cell in column".

If somebody can help with this will be nice.

Mike Wilday

You will want to use an Automation to set the date when the cell becomes 100%. Then you will want to use a vlookup in the other sheet to grab the date if it's populated in the first sheet.

Reference for using Vlookup: https://community.smartsheet.com/discussion/80438/automation-copy-cell-value-to-another-sheet

Reference for automating a date: https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action

Reference for using a vlookup formula: https://help.smartsheet.com/function/vlookup

I hope this helps!

ultimatum

Mike Wilday

Aug 16, 2022

You will want to use an Automation to set the date when the cell becomes 100%. Then you will want to use a vlookup in the other sheet to grab the date if it's populated in the first sheet.

Reference for using Vlookup: https://community.smartsheet.com/discussion/80438/automation-copy-cell-value-to-another-sheet

Reference for automating a date: https://help.smartsheet.com/articles/2481986-set-the-current-date-with-record-a-date-action

Reference for using a vlookup formula: https://help.smartsheet.com/function/vlookup

I hope this helps!

I don't want to set a date.

I want to copy data from another sheet with the already provided date of a specific task in the column when will be added row with task complete (100%). All data to this sheet is provided from the form.

The data must be copied to specific cells automatically.

If it is not clear, I will try to add a screenshot.

Mike Wilday

Oooh. Sorry. A screenshot would definitely help. Are you trying to copy a date from another row? Or the same row? That may matter too.

ultimatum

Below attached screenshot.

1. All information will be provided using a form.

1. Main sheet where all data will be coped.

Michael Culley

How about in your date column on your main sheet you do a formula like

=iferror(if(index({OthersheetTask4Column},match([primary_column]@row,{OthersheetPrimaryColumn},0))=1,index({OthersheetDateColumn},match([primary_column]@row,{OthersheetPrimary_column},0)),""),"")

Then follow that same idea for the installation column, mechanical, etc

Michael Culley

Basically if the Task is 100%, pull the info from the date column, Installation column, Mechanical column etc otherwise leave it blank.

Mike Wilday

Do you have to have separate dates like that on the main sheet? A separate date for Mechanical and for Installation? From your samples, it seems like using the Automation Copy Row would do the trick. You'd have the same data, date, name, and task. Would that work?

Automatically move or copy rows between sheets | Smartsheet Learning Center

https://help.smartsheet.com/articles/2479626-automatically-move-or-copy-rows-between-sheets

With the Move rows and Copy rows actions, you can automatically move or copy a row to another sheet when conditio