use logic formula to copy an entire line to another sheet
Hi everyone!. I´m from Argentina and 1)thanks for helping 2)sorry for my english!
I need to learn how to use a logical formula in SHEET A to copy an entire line to SHEET B, if one of the columns of the line to be copied has a "R" status ("R" from "restriction" that line has)
When entire line appears in SHEET B, I need to process/edit it to change "R" status to "OK" status. When this new status changes in SHEET B, I need to delete "R" status in SHEET A.
So my formulas have to be something like:
1) IN SHEET A: =IF "R"; copy entire line to SHEET B
2) IN SHEET B: =IF "R" changes to "OK" then DELETE "R" from SHEET A
I´m working on construction management, in a template for LAST PLANNER SYSTEM...a methodology for LEAN CONSTRUCTION...so restrictions in activities are very important to define and resolve...
Thanks again...waiting for some help! in...3...2...1....
Comments
-
Hi Dany,
There are a few different ways to structure a solution.
How many rows can there be in the sheets? How many columns can there be in the sheets?
Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) 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 / CEO @ WORK BOLD
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.8K Get Help
- 406 Global Discussions
- 218 Industry Talk
- 457 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives