-
Linking Cell Values From a Cell With a Formula
I am trying to create a workaround using the cell linking function in order to avoid circular references. In the picture below, the Premium column contains formulas calculating the appropriate total. Is there a way to have the Bound Premium column show only the value from the Premium column without carrying over the…
-
SmartSheet Reports have limitations that make them useless for business
We recently learned the hard way that there is a limit to how many sheets a report can access! We use the report feature to create individual task lists throughout our company. Each task list searches all sheets for names in an Assigned To column and refines the search looking for a value of "Needs Action" in the Status…
-
Unicode Text Symbols are extremely useful
Please send me an email if you would like to be added to the workspace. kriswalsh@gmail.com I love Smartsheet's native symbols and use them all the time. That being said, there are times when I wish I had more options or flexibility with them. I am sharing the following with the hope that: 1. Someone finds it useful. 2.…
-
Sorting from a drop down list that parallels parent row hierarchy?
I use the sales pipeline by stage sheet and love it. Typically, we manually move rows between our stages, which are set up as parent rows. I use the stage as the parent so I can easily keep track of my totals, which gives me trigger points for action on issues when sales may get slow. I also derive all of our sales…
-
Cashflow Overview from Date columns
Hi all, i have checked almost every single discussions, but still looking for my solution: Case: building houses with 6 payment steps from our customers (revenue), and consider 6-8 payment steps for our contractors (cost) Note: this part we are able to do 1.) finally have a mastersheet with follow columns: January-December…
-
Smartsheet merge in Google Docs: list sorting and/or filtering
Smartsheet Merge in Google Docs is a very useful add-on that I use very often. I can adjust a lot of things (creating/sharing/uploading GDocs and PDFs, as well as sending them to specific clients via email - just awesome). My only pain is to find the specific rows in a huge list of clients in the “Select Smartsheet Data”…
-
Improving the context of answers to community questions
Hi all, can I suggest that as there are lots of new users to the community since it was launched only a few months ago, that existing and new members add a little detail about themselves? That extra info should make it easier to see the context in which a question is being framed, so the answer is more appropriate?…
-
Merging inventory
I have an inventory I do each month and have a fairly simple question but not sure what is the best way to complete this task. I have 3 columns. ItemNumber, ItemName, and TotalQTY. The first sheet is what I actually have on hand in the warehouse the second sheet is what our system says we should have. So far very simple.…
-
Linking Sheets and Sharing
We have a sheet being kept up by our quoting group listing such things as customer name, quote number, amount of quote, etc. This includes the sales person. We keep a similar sheet for orders that have been entered. We would like to keep these two sheets separated by group that uses them, and they use some formatting to…
-
Using a master list column and being able to link to other sheets
I have a question in regard to creating a dropdown list column. I want to be able to have a MASTER list that when I add a new item to the list that it will update to other sheets that contain the same list. Is this posible. I can see that I can copy and link rows to other sheets but it would appear that I cannot format a…
