-
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…
-
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…
-
Joyful Animations - in Smartsheet!
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.
-
Auto-hide helper columns
I'd like to be able to tag or categorize certain columns in my sheets as "helper" or "auto-hide" columns. Then, I'd like to be able to quickly hide all items with that categorization with the click of a button. I imagine it like a reverse "unhide all columns" button, but only for the columns I've designated. This would…
-
Trying to sum columns based on value chosen from linked sheet
Scenario: I have 2 sheets: "AFE" and "Lines". There is a 1-to-many relationship between AFE and Lines (one AFE may have many lines), but I haven't set up parent-child in "Lines" because users will add entries in any order and I can't enforce any kind of sorting or parent-child relationship. In "Lines", there is a linked…
-
Prevent auto complete from suggesting "acres"
Having a weird annoyance where typing in certain numbers leads to autofilling "acres" to the end. Happening across multiple sheets and across multiple users. Anyway to prevent this? Few Examples: 6.346, 6.424, 6.423, 6.373
-
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.
-
Customer support phone number or any kind of help.
can someone help me get in contact with support? I need to access my sheets. It is ridiculous how long it takes to get support having been a paid customer for as long as i have. The lack of help is preventing me from starting a job that requires a schedule as part of the pre-construction process. I've had to use other…
-
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…