-
Alphabetize Filter Options
In one of my sheets, I can create a filter for the field "Project Manager" In the field(s) Show columns that match...if I click the dropdown arrow to give me the options for selection, I do, in fact, see a scrollable list of project managers - out of order - How can I alphabetize this list?
-
Sheet content, shifting rows
Oh boy I have a good one today. Please Help! On Friday I was working on my data base sheet, linking cells in a couple different columns to another sheet. (I hid the columns in between, to make it easier). Today, I noticed that the columns in between have shifted down a few and the further I get down them worst it gets…
-
Filter not Working: Is not in the last (days)
Hello, I'm drawing a blank on why this filter is not working correctly. I process the archive of the data in this log and will archive every week the items that are 21 days or older. This is how I have my archive set up and it always returns items that were submitted today (which most certainly does not meet my filter…
-
SUMIFS with multiple matches
I am trying to create a Smartsheet SUMIFS formula where if the value in a cell in column 1 is not blank, and the value in a cell in column 2 is US Commercial, and the value in a cell in column 3 is 2019 and the value in a cell in column 4 is 4.. I.e. for any rows where there is a match for - deal id is not blank, where…
-
Support function on account?
Hello, I have raised a ticket twice for the same issue and have yet to receive any reply a month later. I have taken a screenshot the second ticket raised to capture date and ticket number as nothing was received for the first ticket created. The issue itself isn't a huge problem, I am more concerned that we have no way to…
-
Limiting the dates that print in Smartsheet
I want to create a Smartsheet project that has a Start Date of July 1, 2019 and End Date of September 1, 2020. I want to set the timeline to Years/months. When I view or print it, I only want to see the months associated with 2019 and 2020 and I don't want to see any months in 2021. How do I do this? I can't hide the…
-
Date Format
Hello, When I set the column type as "Date", I need to be able to choose different formats. For example, it currently defaults to MM/DD/YYYY, but I need the column to default to MM/YY or MM/YYYY. This data will then be pulled to another application (Domo), but it needs the correct format when being transferred over. How…
-
Trying to expand my knowledge of writing formulas
Im having a little bit of a hard time trying to make formulas longer and saving column space(s). For instance when I run into an issue of creating a formula in 1 cell i sometimes create a new column and put the formula I wanted to add in there. This takes up space which can be free'd up and when the sheet gets over 1000…
-
Capture Row history using API?
I am trying to build a UI using Google scripts to display the changes made to any given row. In other words, I want to capture a list of modified date, modified by and what was changed in a row if any cell in the row was updated.
-
Reports not refreshing, again
Hi I'm finding that reports are not refreshing accurately when the underlaying data, in a smartsheet, has changed (and been saved before you ask). The source data is around 20 rows so this should not be a problem. We have seen this issue previously. It seems to fix itself - i.e. we make no changes and suddenly the report…