-
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…
-
Alerts For When Nearing 5000 row Limit
Is there a way to set up an alert on a sheet for when it is nearing the 5000-row limit? Thanks!
-
Task Dependency Block View
Would be awesome to be able to see projects in a format like that used by Casual.pm. Gantt charts make it very easy to see how tasks lead to deadlines, and to identify critical paths, but they are not great at immediately showing how tasks depend on one another, nor the total number of processes in action at any given…
-
FILE UPLOAD ERROR
Is anyone else having trouble uploading files to a row or sheet?
-
Form Confirmation Email Subject Line Customization
Is it possible to modify the subject line of a form confirmation email? We would like to be able to add a field to the subject line so that when it is sent, it not only has the Smartsheet name, but the client name that email is referencing.
-
Blank Rows in Gantt - Automatically get populated by start date
In Gantt format - I leave some rows blank to separate workstreams or buckets of work. But for whatever reason - Smartsheet goes and fills just the start date automatically in these row. I delete them, and then after I save, they come back again. They are harmless, but misleading and hurt the aesthetics of the chart. How…
-
Sheet Reminders not working
Good afternoon, I use the Row Reminders religiously and since last week this function has been hit or miss. I created several row reminders for various sheets on June 11th to come to my Outlook inbox June 14th. All reminders created are still sitting in Smartsheet. I've voiced this issue to support earlier this week and…