-
Integrating Smartsheet Reports, Power Automate and Smartsheet API
Manual task automation isn't just about saving time; it's about building a reliable, repeatable, and secure pipeline. We recently took a standard user-provisioning process that previously required 15 to 30 minutes of manual administrative effort per run and reduced it to a 1-minute automated execution. By connecting a…
-
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…
-
Operational issue due to new licensing restrictions - seeking ideas
Hello! I'm seeking ideas / work-arounds / the right language to convey the barriers and suggest enhancements in response to the new licensing restrictions. Here is my context. I used sheets to format a 'clinical trial transparency report card' (image below). This sheet curates institutional data from ClinicalTrials.gov…
-
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…
-
reset your authenticator app settings.
I lost my phone and now unable to find the authentcation code in the microsoft authenticator app. I need to reconfigure it. Please advise how to go about it.
-
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!
-
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…
-
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…
-
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…
-
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…