-
How to reference the <CELL ABOVE>
Is there a way to reference the cell above? example: =IF(logical_expression, value_if_true, <CELL ABOVE>) The simple way is to reference using [COLUMN_NAME]2 (the number being the current row number minus one). But this is broken anytime a row is deleted, which happens frequently on our sheet. I have tried adding an…
-
Enhancement Request: Viewer Security
I've requested associated items to this topic before. Here's two new ones: 1. Do not allow Viewer to Save As New. This one is pretty straight forward to me. Is there a Use Case where the Viewer SHOULD be allowed to effectively take ownership of their own version of the data? 2. Add Alert (Notification) when any user…
-
Dynamic lookup for Project Master Rollup
I would like to create a master project rollup to track projects, and do not want to set up cell linking every time a new project is added. To this end can we create a dynamic lookup so all the user has to do is type the name of the sheet referencing the new project into the master rollup?
-
email data from smartsheet nice visuals
Hello, we are looking for a nice visual way to email data from smartsheet to clients regularly, without having to take screenshots or do anything manually. any ideas of how to do this within an email body? Ideally we would love to email a dashboard but this doesn't seem possible
-
Overflow Text (Cell wrapping mode)
Dear smartsheet developers, please implement this idea into your powerful service.
-
Multiple, comma separated values in one cell
Hi I'd like to create a report which returns all rows that have a certain value in column 'Donors' - i.e. we have activities that are funded by one or multiple donors, and I'd like to return all activities that are funded by Donor X. Conference one - donor x, y, z Conference two - donor y, z Three - donor x And the report…
-
Enhancement Request: Formatting for Reports
There are numerous posts on improving formatting on Reports. Here is a specific use case: I have a sheet with multiple date columns and tasks. On one report, I am showing (either Gantt or Calendar) view of the tasks color coded by task. In a second report, I would like to show the dates (either Gantt or Calendar) view with…
-
New way to open and control multiple sheets on the top bar
I like my sheets in a certain order and would like to see certain sheets opened as a group. This can be done now, but it is awkward. I would like to see the groups color coded with small tab on the end of the group to move or close the group. http://screencast.com/t/R7xKPyXHN Shows a mock up of how this would look. For…
-
Would like to see the following enhancement regarding Symbols
We often have indicators that are positive if being reduced. It would therefore be nice to have corresponding symbols. Thus the inverse color scheme for the arrow symbols. Down is green and up is red.
-
Populate Start/End Date based on Status change
I use the Card View for quickly creating tasks and tracking their status/state. I'm trying to see if it's possible to take this further and populate the Start Date and End Date fields when the task first enters a specific state. See screenshot attached.
