Returning entire row
I want to Pull Data from a sheet name (Daily Sales Sheet) to another sheet (Payable).
This is the entire row from Daily Sales Sheet.
In (Daily Sales Sheet) there is a column by the name of payment method. If any cell in column marked as Payable, that entire row having customer name, service and other details should reflect in (Payable) sheet.
Also, if there is a duplicate entry of that customer as Payable, I don't want it to be reflected the entire row again, just the value of "Balance" column would be added in previous entry so that I know this customer owes this much.
Is it possible?
Answers
-
Hi @Kuldeep Gera,
Are you trying to create a new row in the Payable sheet every time a Payment Method is marked Payable, or do the rows exist in both sheets and you just want to mark them?
Smartsheet cannot create rows unless you use the Move Row or Copy Row features, but the sheets need to have the same structure.
If you further clarify, I can try to help you.
Cheers,
Ramzi
Ramzi Khuri - Principal Consultant @ Cedar Tree Consulting (www.cedartreeconsulting.com)
Feel free to email me: ramzi@cedartreeconsulting.com
💡 If this post helped you out, please help the Community by marking it as the accepted answer/helpful.
-
Hi @Ramzi
The row needs to be created in the Payable sheet everytime a entry is marked "Payable" in the Daily Sales Sheet.
But, if the row needs to be created for similar customer again, then it shouldn't create another row instead just add the value of it in the previous one.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 430 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!