-
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…
-
Date Formatting
I'm trying to create a rule so that if an 'install date' is before a 'product received' date then the install date will highlight in red. Any ideas on how to do this? I tried rules and filters, but it wants be to chose a date for my condition (not the date in another column). I did this a long time ago and I created a…
-
Showing completed items 8 days after completed
Hello, I am trying to make my report so that if an item's status was changed to complete in the last 8 days that it would stay in the report so that our client can see it was completed within the last week. I've figured out a way to do it in the sheet but not in the report. I there a way to do it in reports?