-
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…
-
Hyperlink to "Save as New"
Is there a way to create a hyperlink on a form that then leads to a Create as New menu so that people can easily create copies of an existing folder?
-
edit rows and columns from web form
Hi, are there plans to add the feature to edit/update rows and columns through web form? it would have save me a lot of time if I could do that. thanks.
-
Cannot Copy Chart Formats with New Data
Hello, When I copy a graph on the dashboard it keeps the same formats (color scheme, grid lines, etc.), however when I change the data I want to look at it completely reverts back to defaults even if the data is the same # of cells and the same type of cells. Is there any way to keep the same formats but change the data…
-
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…
-
Employee Objective and Performance Reviews
I am looking for a real-world example of someone using the employee Objective and Performance Review Template for an IT manager? Do you find it useful and easy to use for managing your managers? Anything you can share would be greatly appreciated.
-
Pie Charts and 2 rows of data - Possible Bug w/workarond
Just submitted this to Smartsheet, thought I would share with the community to see if it was indeed a bug, or if anyone else has experienced the same? Bug: I have a report with two lines of data showing... When reflecting that data on a dashboard, I am unable to select a pie chart when there are only two lines of data from…
-
Logging into Smartsheet
Hello all, We have 3 licensed users, and one of my colleagues set up a free trial it has now expired and he would now like to transfer his sheets to another log in for him but using the same email address. I have tried deleting the account then going in to 'sign-up' but smartsheet seems to remember his email address and…
-
IOS app changes cause values to become hyperlinks on export
In the past month or so, when I make changes to data in a sheet using the IOS app, those changed values become hyperlinks to the word. For example, if I change a cell value to the word "other", it makes the value in Excel "http://other/". It makes the exported spreadsheet confusing with a bunch of hyperlinks in it that do…
-
Formula to count revenue that has been won but has not started billing yet
I have a formula that counts the revenue if the stage is "Closed Won" =SUMIF(Stage:Stage, "Closed Won", [Monthly Revenue]:[Monthly Revenue]) Now I need to add another that references the "Go-Live Date" Date and add up what has been won but is less than 30 days past the go live date