-
Quick Tips and a list of Frequently Asked Questions
Quick Tips for engaging in the Community 🔎 Search before you post: Before you create a new post, search to see if your question is already out there. 💬 Be descriptive: Include screen shots and as many details as you can when asking questions or providing an answer (without exposing sensitive data). The more details you…
-
Outlook Calendar integration showing time of event and not just the day,
Smartsheet is great for planning events but when that date is added to an Outlook calendar, it shows up as a day event and not the specific time of the event. Not only does it look like a day event but the inability to change the calendar to the appropriate time of the event is creating more work. It would be great if this…
-
Jira Connector Error - Illegal Character
Hello, We are working on a bi-directional sync via Jira Connector and continue to receive this error when we try to push new tickets into Jira from our Smartsheet (which is successfully receiving Jira updates and updating existing tickets) - JIRA rest client exception occurred while syncing issue.…
-
Odd behavior with Index(Match
Using a basic Index(Match on 1 criteria to cross reference 2 sheets. I've checked multiple times that 1) the cells pulling in are actual numbers (no formulas), and 2) there is a MATCH to pull in. Here is the formula - appreciate help on what I'm missing =INDEX({Equipment Leadtime - MPTs MVA Limit}, MATCH([MPT…
-
Publish Report without Attachments
I have a sheet that I used to create a Report with only certain columns and rows displaying that I want to publish/embed into SharePoint to allow people to view the information in a read-only view and see the latest data. I do not want them to have the ability to access the attachments for these rows. It doesn't look like…
-
Hide Attachments and Comments on Reports within WorksApps
We have some internal sensitive data saved as attachments that we do not want our clients to see. I have hidden the Attachments and Comments Column on the Reports and saved them as View Only within WorkApps. However, the users can still view the attachment even though I have hidden the Attachment column, by right clicking…
-
Anyone having problems with reports not including summary information?
Good Morning, I've been attempting to export a report. The export always comes up without summary information, regardless of the export or send type. Above are screen shots of the report and export. Any help would be greatly appreciated.
-
Approval Requests
Hello, How do I set up an approval request to multiple people but only one person needs to approve?
-
Adding a row via API using cURL adds blank row
Hi all: I'm attempting to add a child row to a sheet using the API and cURL. It took some time but finally, taking information from chatgpt and other sources, I was able to get a row added as a child in the proper place. However, the row is blank and not taking the values I am setting. curl -X POST…
-
Assistance Needed with Cross-Sheet Formula Set Up
I’m trying to use a cross-sheet formula to pull data from my Primary Sheet into my Secondary Sheet in Smartsheet. My goal is to display the "Idea #" and "School Name" from the Primary Sheet in my Secondary Sheet for every row where the "Yes/No" column in the Primary Sheet has a value of "Yes." Primary Sheet Details: Column…
