Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for July 2017
Discussion List
Adding information to templates
I am trying to work out the best way to do this. I have an evolving list of products (hundreds and hundreds) that can be ordered, and 29 people (only - this is set) who can order them for a Bulk Buy once a year. My current plan, was to create a Template, then have a sheet for each person. This way I can request them to…
Combining Data from Multiple Sheets in a Sight
My team and I are having a problem with the combination of data from multiple sheets showing up in our sight. Originally, we had a couple sheets that all had formulas returning data at the top of each sheet. I then cell linked the cells from these sheets to allow one sheet to add them all together. This then allowed just…
Query String Syntax
I am having an issue with a query string syntax. See below. Trying to populate two fields when I send this out. I actually wish I could populate the form from data in the sheet but i dont think I can. Please take a look I have tried multiple different things Trying to populate an Order Field and a Name field…
Invalid response from JIRA. statusCode: 400 during Smartsheet for JIRA Workflow sync
I have set up a Smartsheet for JIRA Workflow and keep getting the below error message (screenshot also attached) for any rows created in Smartsheet (vs. ones originating in JIRA): Invalid response from JIRA. statusCode: 400, reasonPhrase: Bad Request statusCode: 400, reasonPhrase: Bad Request What I want to do is use…
Automate RYG balls
Hi, I am just getting started with formulas. I'd like to automate the colors of my RYG symbols based on the dropdown options in another column (see screenshot). If Status column is Event Scheduled - Green If Status column is Event Declined - Red If Status column is anything else - Yellow. Can you tell me how I would write…
Report Builder: Adding Columns
Hello, I am building a Project Repository in Smartsheet. I am creating instructions for how to build a specific project report from the repository and looking at the report builder. Is there a function to be able to "select all" of the "columns" to be included in the report? In addition, is there a way to set them up in an…
How to Countif only the un-checked boxes in a column (leaving out blank boxes)
I understand how to countif the checkboxes in a column with the COUNTIF=([range]:[c],1) such as shown in this community post: https://community.smartsheet.com/discussion/counting-checked-boxes But I want to be able to count the boxes that are un-checked. I used CountIF=([range]:[c], 0) but it gave me the other blank boxes…
Smartsheet Comments not Displaying on Sight
I have a fairly simple Smartsheet with a report that uses just that sheet then the report is displayed on a Sight. The comments column displays on sheet and it displays on the report. But the Comments column is missing from the Report in the Sights widget. Is there a way to make the Comments (and the attachements column…
Notifications - Direct Link to Changes in Specific Columns
Hi SS Community - We're looking to make discussions in Smartsheet easier for our users. Currently we have the notification set to address changes and additions to the comments column. The custom email is nice, but it's not exactly user friendly. Is there a way to hyperlink to an area of a smartsheet where a change was…
Webform - Requesting an email
Most of my Webforms have a section on the bottom for the technician receiveing the form to fill it out and complete the form - I would like to put the request for a copy above the section that we fill out. Can that be made movable??