If we have a smartsheet of data and want to say "if this column says AMA, copy it to a different she
If we have a smartsheet of data and want to say "if this column says AMA, copy it to a different sheet" and still have it linked so when we update the original sheet, the copied sheet updates??
Best Answer
-
Hi @bday2329,
I don't think its possible to do bidirectional updates between sheets. You could create a report with just "AMA" data. Changes in the report post to the sheet.
Not sure this is of any help.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @bday2329,
I don't think its possible to do bidirectional updates between sheets. You could create a report with just "AMA" data. Changes in the report post to the sheet.
Not sure this is of any help.
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
Here's more on Smartsheet reports.
-
Hi @bday2329
If you want to copy a row to another sheet (already set up) we could use-cross sheet formulas and the new Column Formula to keep it updated as long as we have something unique we could reference.
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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
-
Thanks can you provide an example of the formula?
-
Here is what I have for a formula
In my copy to sheet I have a column formula of
=IF([Item Number]@row = {Item #}, {Col 3})
I am trying to check the copy from sheet by Item number and if a match is found use the value in column 3 from the copied from sheet in the copy to sheet
AAATESTSheet 2 is the copy to sheet
-
I hope you're well and safe!
Excuse the late response.
Did you get it working?
Be safe and 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.4K Get Help
- 424 Global Discussions
- 221 Industry Talk
- 464 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 144 Just for fun
- 61 Community Job Board
- 463 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 300 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!