-
A-Z Rows
hi ive set up a couple of new sheets and looked to sort the rows A-Z but wont allow me? any ideas to fix this problem ta
-
Sights needs some improvements
Sights has been out for about six months now, but there are still no graphing widgets. When is SmartSheet planning on coming out with this functionality? Graphs are some of the main things people will look at when viewing a dashboard. Currently all we can do is list a whole bunch of raw numbers with little to no visuals. I…
-
Linking colums from one sheet to another issue
Good morning, I am trying to set up a master document with linked cells across three different sheets. First being an order form, second being a shipping form and third being an install form. All the information will link back to my system ID of which system is being installed. My question is when I highlight my cells I am…
-
Cross-sheet reference limit clarifications
We have a couple cross-sheet reference questions: * Where can we see how close we are to the 25,000 cross-sheet reference and 5,000 cell-link limits? Also, is there a go-to link to these references? * Clarification please: We have one Master Sheet and 3 other sheets that refer (pulls data from) the Master. Does the…
-
How to create a non-updating widget with key background/info
What kind of widget do I need to create to present basic descriptive text (background information) about a project? I’d like to pull the basic data from a sheet that is seldom updated. The widget would be in a report about a real estate transaction. Background data I’d like to add in widget from the non-updating sheet…
-
Count number of days between two dates and return the difference and if early or late?
Hi there Smartsheet community, I don't know if anyone can help me? I am trying to work out a formula to calculate the number of days between 2 dates, and also return if this was early, late or on-time. For example: Column A- Start date (20/06/2018) Column B - End date (31/05/2018) Column C - 20 days Early OR Column A-…
-
Using reports to create Totals
Hi I am pretty new to Smart Sheet and have mainly used it for Project Plans so far. I am now looking at using it for forecasting for delivery consultants. I have created a sheet and form for them to enter forecasting for delivery for a particular customer in a given month. I would however like to be able to create a…
-
Building a formula to connect multiple cells between sheets
I understand that Smartsheet is not automation tool, but would like to make team's work easier without having to enter lots of information manually. Situation is that that we have two files: pipeline and quote. Once the quote is completed, there is a series of Values, about 40, which need to be called up on the Pipeline…
-
Cross sheet reference multiple cells by dragging
Hello everyone, I would like to reference multiple cells in the same column from sheet B onto sheet A. I thought I could create a reference formula on Sheet A to pull the value from sheet B and then drag that same formula down onto the rest of the cells but noticed that the formula does not change if it is dragged. Is…
-
2-Way Cell-Linking
I frequently link cells because it is very convenient. Could it be possible to enhance this, so that one doesn't have to use "Go To Sheet" in order to update the value? In other words, can we have 2-way linkage, so that if it's updated in either place, then the value has been updated? I constantly have to go to source…