-
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
-
Feature Request: Allow a Comments field for the entire sheet
It would be great if I could look at the sheet properties and have a section to place a comment pertaining to the entire sheet - sometimes it's useful to have a note on the purpose of the sheet and other useful information for users. The comment would apply to the entire sheet not just individual rows.
-
How do I attach one smartsheet to another?
Hello, I am trying to place an entire Smartsheet page as an attachment in another page for quick referencing. Upon selecting to attach a document by click and dragging into the provided window or uploading from computer, Onedrive, etc; I am not able to drag a complete Smartsheet page into the box, nor is uploading from…
-
Value in same row, different column
Hi. My ultimate goal is to list the next upcoming task in a project. I have found a way to find the date of said task by creating a new column and searching for the minimum due date of all tasks which are not yet checked "done" (this was a ridiculous undertaking in and of itself, but oh well). My next task is to return the…
-
Performing Calculations if Cell = ""
Hello Community, I have a question on what the optimal solution is to a calculation I would like to perform. Here is what's there: In one column I have job title - based on if that cell = "[title X,Y...]" then I'd like to perform a calculation based on four other columns that have calculated values in them - but the weight…
