-
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…
-
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…
-
Identifying Sheet/Report Dependencies Across a Workspace
Hello, Is there a way to identify the dependencies of a sheet or report across a workspace? Specifically, I’d like to see which reports rely on a given sheet and whether those reports feed into dashboards. I’m not referring to usage metrics such as views, but rather how assets are interconnected. Thank you!
-
Move data from one sheet to another without a Data Shuttle
I have my main sheet and I have a second sheet that where a Data Shuttle (staging sheet) is ran and then it filters out duplicate data. Is it possible to move the data from the staging sheet to the sheet in a way that does not require it to be exported to excel? Is a DataTable an option to upload from the staging sheet to…
-
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.
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
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…
-
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.
-
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