-
Automate dashboard?
Dear SmartSheet Community, I hope this message finds you well. I'm reaching out to inquire about SmartSheet's capabilities for automating the creation of weekly and monthly reports. Our objective is to streamline our workflow by eliminating the need for manual report generation. We are particularly interested in:…
-
Jira Connector subscription
I'm trying to reach out to sales or support team to subscribe to Jira Connector and resource management, but unfortunately with no response and cannot find from where I can subscribe with direct link, knowing that I'm subscribed to business plan
-
How can I track when a ticket is past its number of SLA days??
Hello, thank you in advance with helping with this question! Please see below: Situation: My team uses a Smartsheet intake form to take work requests from other teams. This populates into a sheet with the needed information to move tickets to different status' (ex: New Request, Active, Backlog, Triage Required). All of…
-
What cause a user/project id to change?
Hello, My team is using Smartsheet's data of my organization to one of our application. We reuse UserID and ProjectID from Smartsheet and store them as primary key in our database. However, occasionally, I saw the ID of a same user or project is changed when pulling data from Smartsheet. May I ask what might cause this to…
-
Sheet permissions
When I share a sheet with anyone from my account with editing permissions, they can edit the sheet on the mobile app but not from a computer. Yes, they also have a Pro account and it also shows the proper permissions on the "share" page. I have used Smartsheet at my last job extensively and know the software quite well but…
-
Clone cells or rows?
Hi All, Hope you are well. We currently use Smartsheets as part of our product management and planning. We have a Sheet with all our current development work some of which has been started and some of which has not been started, the problem is this sheet is getting quite big with all our current and upcoming work its named…
-
How can my index/match formula include a column that has multiple values
Ok so I downloaded an inventory management template that is awesome! When people submit a request form for a ppe item they need, it has index/match forumlas to show us what Current Inventory remains. Its great! However, they are only able to select one ppe item from the drop down list. And I need them to be able to select…
-
How to turn on notifications for sign-ups?
I have created a SmartSheet sign-up for an event I am hosting and it looks great. However, I am not receiving notifications when people sign up with the sheet. Instead, I've been refreshing the page every morning. Is there a way to turn on notifications for sign-ups specifically within a sheet? I've already gone into my…
-
#INVALID COLUMN VALUE error
Hello Community, I'm trying to combine two formulas but keep getting an error. The first formula sums children if it's a parent row or leaves the cell blank. The second look for the most recent data in a row (I have month in the columns from July to June). They work independently but when I combine them I keep getting an…
-
"copy row to another sheet" - Sometimes row gets copied down at the bottom?
Hi, When there is a workflow to copy a row to another sheet, why does the copied row sometimes appear down at the bottom of the sheet, leaving ~50 completely empty rows in-between the last row or text? I know technically smartsheet must be sensing that the rows in-between are not empty, but does anyone know what causes…
