-
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…
-
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…
-
Chrome app closing without a warning
Hi all, When I run smartsheet in chrome browser, if I try to close the tab and there are unsaved changes, I get a warning about that. However, when I use the chrome app, if there are changes to be saved and I close the app, then it closes without any warning, and hence those changes are lost. Is there any way to fix that…
-
Web Form Submissions Disappearing
Hello, I have a web form that I'm using to collect information, and it has been brought to my attention that a number of rows that were submitted by users, and for which they received confirmation emails, never showed up on the sheet. This poses a huge problem as each submission represents a request to process a payment,…
-
Relationship between the "Status" column and other columns
I'm relatively new to Smartsheet, but it seems strange that the Status column appears not to have any relationship to other columns in the project sheet. But maybe it's possible to use a formula somehow to do that? Some specific questions: * If I change a task from Not Started to In Progress, can I set up Smartsheet to…
-
O365 Integration for unlicensed users
We have a Business plan with 15 licensed users, then will invite perhaps another 100 collaborators (unlicensed users) as part of the various projects across enterprise. All same organization. We are an O365 shop and have integrated all licensed users with O365. However, there does not appear to be anything but a static…
-
Nested IF statement for RYGB only works in one row
Has anyone come across a scenario where your nested IF statements work perfectly on one row, but when dragged to other rows don't apply the conditions correctly? I've added the following statement to row 47 of my sheet: =IF([Percentage Complete]47 = 100, "Blue", IF([Percentage Complete]47 < 33, "Red", IF([Percentage…
-
Sights Widget to Display Update of Any Changes of an Entire Sheet
I Desperately Need Help with understanding how to use a report and/or widget feature to display an automatic update of date whenever anything on a sheet is modified or changed. I would like for this to pop up on the dashboard I am creating as "Last Updated As: 5/5/2017" for an example. Can anyone please help? I have…
-
Smartsheet unresponsive
I logged into my account and all my data is there but the page is unresponsive, I can't even select a cell.
-
Counting A Range of RYG Balls at Once
I have researched and tried the various formulas for counting the RYG balls in one column from 1 row through 540. I have tried various formulas but I keep receiving and error. Can someone help me by letting me know what I am doing wrong? Here are few formulas I have tried. =COUNTIF(CHILDREN([Status of Completion]1:Status…