-
Jira Connector Error Message
I am trying to set up my Jira Connector and am receiving the following error: "Invalid response from JIRA, statusCode: 400, reasonPhrase: Bad Request Could not find issue by id or key". We have the Issue Key set up to send from Jira to Smartsheet. Can anyone point me to a troubleshooting guide with the status and reason…
-
STOCK FOLLOW-UP
Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring something back they also fill in the form and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
-
Can I have 2 users fill out the same form?
Hello, Is it possible to have user #1 fill out the required fields of a form and submit it, and then have user #2 view the same form with the answers submitted by user #1, and fill in any optional fields? I am looking to streamline a process so that it creates one entry in my sheet, rather than have each user fill out the…
-
Do Smartsheet Support an API to fetch header names of a template?
I want to make an API call to fetch the column names and respective datatypes of a user-created-templates.
-
Sort in sheets
Good afternoon, Oh, how I long for sorts within a Sheet to be saved like it is in reports!! We have a set sort we need, but it gets undone throughout the day by other users. When will this be implemented to save the time of having to constantly resort? Also, having more than three sort options for a sheet would be beyond…
-
STOCK FOLLOW UP/ FORMULA/LINKED SHEET
Hi everyone, To improve our warehouse we are making a stock tracking. It works like this: When someone takes something from the stock they fill in a form and tick 'use something'. If they bring something back they also fill in the form and tick the 'bring back' box. In the column 'Quantity left' the amount of stock is…
-
How to connect Smartsheet with tableau desktop on Mac OS
Hi All, I am trying to create a connection to tableau with my smartsheet to pull data into tableau , I am able to do this in windows os using the smartsheet live data connector, but i am not able to find an equivalent for that on MAC os , is there anyway i can make it work on Mac, any pointer /links would be highly…
-
Creating a Milestone Sheet (referencing project plan)
Hi All, I have created a project plan in Smartsheets and am tracking milestones using tags How do I create a separate sheet which only shows me milestones, its start/finish (i.e start=earliest start date with a particular tag, and end=latest end date with a particular tag), its % completion (based on the milestone tag) and…
-
NEW! COUNTIF not blank....
I want to count how many columns have a date in the "SMD/IME Appointment Date" row and where the "Case Closure Date" cell in that column is blank: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case Closure Date], )) Attempt #2: =COUNTIF(AND(NOT(ISBLANK([SMD / IME Appointment Date]))), ISBLANK([Case…
-
Unlicensed/Free users - Pro vs. Plan
Based on everything that I have read online via forums and smartsheet's informational material, unlicensed/free users in pro vs. business plans have different abilities. If a sheet created under a pro plan has free users, they CANNOT edit sheets that they are shared to (add rows, check boxes, etc.). If a sheet created…
