-
Symbol Column description
Can the description of each symbol be changed? Thank you!
-
Two similar formulas, different results
I am working with two ranges, one contains dates and the other one numbers which I wish to have them added by month such as any number that falls within being >= 01/01/18 but < 02/01/18 gets added. This is what I have thus far: =SUMIF($[Payment Date]$26:$[Payment Date]$35, AND(@cell >= DATE([Due Date]87), @cell < DATE([Due…
-
Enhancement Request: Edit Row from Desktop like App
In a Report, when I select Edit from the row menu, I can see all content in the underlying row, even the columns not shown on the Report. When I do the same from the Smartsheet App on a tablet/smartphone, I only see the columns that are in the Report. I would prefer the same behavior from my browser desktop version (only…
-
Filter default settings
I use up to 5 sheets at any one time, each containing information relating to different customers. I frequently need to filter information on any particular sub-client via a text/number column. The default ‘Create New Filter’ uses “contains” for me to enter a unique name of the sub-client, and all rows applicable to that…
-
Enhancement Request: Optional Button on Update Request
Request: Allow us to have the option to not include a open update form button on update requests. Reason: I send scheduled update requests to inform users of progress that is not dependent upon changes in the row, as well as ones that remind people to do tasks. Right now I lock all of the included rows in the update…
-
Managing form-generated sheets
Hello: I am new to Smartsheets. We have been using a form-generated Smartsheet to track decisions about new acquisitions. The Smartsheet is getting so many rows on it that it is difficult for staff to use. I'd like to move rejected resources to another tab, and move decisions made more than 2 years ago to another tab. Is…
-
Sorting Names with Accent Marks
We serve an international client base, and when I go to sort names in a smartsheet I built for a client directory, instead of placing names with accent marks in alphabetical order, the sort places all names with accent marks at the bottom of the list. For example, José would be sorted with the "J" names, but placed at the…
-
Dashboard Error
Hi guys, Wondering if anyone can help me out with a Dashboard error i am seeing? I have attached the screenshots relevant. * The error is presenting on a Dashboard which looks up to a Summary Worksheet, which in turn references the core detailed data. * The Chart Type i have selected by default is a Pie Chart (shouldn't…
-
Autopopulating date/ cannot edit
Hi Smartsheet peeps, I am having date trouble in my project sheets. Below is the process I do: 1. Use dependencies to autopopulate the actual start and actual end at beginning of a project 2. Copy and paste those dates into the grey planned start and planned end columns 3. Edit the actual start and actual end date columns…
-
Template: Team Task List by Priority
Hi Everyone, I'm new to Smartsheet. In the Template titled Team Task List by Priority, there are headers. High Priority, Medium Priority, Low Priority and Completed. My question is: how do the tasks in lines below the priorities get assigned to which priority? Do they get auto-populated to each priority based on something?…