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!
Copy cell by function
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.
Answers
-
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.
-
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.
-
Below attached screenshot.
1. All information will be provided using a form.
- Main sheet where all data will be coped.
-
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
-
Basically if the Task is 100%, pull the info from the date column, Installation column, Mechanical column etc otherwise leave it blank.
-
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?
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!