-
Automation not triggering
Hello Community, I am having issues with an automation not firing, not sure what is tripping it up: Also I am unsure if I should see the Update Request icon highlighted in the left margin, when this fires? Of course if I manually click to send an Update Request, it does highlight, but I am trying to set this up so that it…
-
Date column auto update when changes are made
Hi, I have a sheet that lists a bunch of different sheets and workspace. On that line I have a date column when it was last updated. I was wondering, can I get that date column to auto update when a different sheet has changes made to it? Or somehow create a dashboard or report that mimics this.
-
Rotate View for Attachments
Please create a way to rotate the view for attachments in Smartsheets. Right now you have to download the attachment to change the rotation.
-
Mobile App
Is anyone else having an issue using the mobile app? I have an employee that is unable to use the iphone app. When logging in, it just keeps going back to the log in screen.
-
How to stop a column from rounding to the tenth place decimal?
I created a sheet to track employee time. The employee submits a time request and the supervisor approves through an update request. The amount of time requested is added to a text field column and I have set the decimal place in this column to 0.00 multiple times. However, the grid keeps reverting back to the tenth place…
-
Formula to Flag Duplicate Values
Hi - I have been trying to create a column formula that will flag duplicate values in my [SKU] column while leaving the first occurrence unflagged. Some of the values in the [SKU] column are either Blank or "TBD" so I would like to ignore those values. My ultimate goal is to be able to filter my report from this source…
-
How can I stop my number field from rounding to the tenth place decimal?
I created a form and grid to track employee time. The employee submits a time request which is then sent to the supervisor using an update request for approval. The amount of time requested is added to a text field column and I have set the decimal place in this column to 0.00 multiple times. However, the grid keeps…
-
Best Way to Create a Stacked Bar Chart from multiple columns
I have a sheet that I pull into a report. The report I then want to use to make a stacked bar chart and put into a dashboard if I can. The columns I am trying to make into a stacked chart are: Lead, project and phase. The issue is that there are several leads and I need the stacked bar chart to show in different colors for…
-
Keyboard Shortcuts in TABLE View
Moving from Grid View to TABLE VIEW, we lost keyboard shortcuts such as CTRL+Down arrow which takes you to the lower-most filled cell. Same with CTRL+Shift+Down (or left, right, up, etc). Mimic the keyboard functionality that we have in Excel and in Grid View!
-
Automatically Setting a Future Date Based on Criteria
Is there a way in Smartsheet to automatically default a date column to 30 days in the future based on certain criteria? For example, if Column A has a value but Column B is left blank, can Column B be set to automatically populate with a date 30 days from today? I tried creating an automation where the trigger is when…