-
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…
-
How to link Task Start and end Dates to another project template file using a formula
I would like to update one task in another project sheet and have it automatically update on another sheet that showcases the more detail project specifics about that installation. I have thought about using the Index and Match formulas, but that would have to hard code the date and the date would be changing.
-
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…
-
Formula To Set Urgency Based On Multiple Criteria (Fields)
Hello, I have a sheet that lists requests, and I want to write a formula for the Urgency field (Critical, High, Medium, Low dropdown options). Estimated End Date Actual End Date Users Affected Work Blocked Users+Blocked Urgency Status 06/19/26 06/12/26 15 No Completed 06/11/26 17 Yes ! Critical In progress 06/15/26 5 Yes…
-
Allow "Undo" after Save
When I make a change to a grid and save it, I am no longer able to undo that action - the only recourse I have is to have my rep restore a previous version of the grid. Let us undo!
-
Using Forms to trigger the creation of a new Sheet
It would be valuable if Smartsheet Forms could trigger the creation of a new sheet from a predefined template or configurable sheet structure. Use case: standardising project plans In an enterprise environment, we often need to capture mandatory project setup information through a form before work begins. This ensures…
-
Form timeout errors
Hello, We have a Smartsheet Form that our teammates fill out & add attachments for invoice processing. The form does have conditional logic in it to cover various scenarios. The issue that we've had for a while, is occasionally teammates will get the error when submitting the form . We weren't able to submit your form…
-
Count Blanks from Referenced Sheet
Hi all! I am attempting to count the Blank cells in the 'Assigned to' column of another spreadsheet and have it not include the blank cells at the bottom when the rows are also blank. This is the formula I'm using now, but it is counting those blank cells/rows at the bottom of the reference sheet: =COUNTIFS({Deposit…