Welcome to the New Smartsheet Online Community
You’ll notice that things have changed a bit. If you need help getting oriented, please take a look at the posts here in the Welcome to the Community category.
API/Developers
Discussion List
-
Card View - Conditional FormattingAccepted AnswerFirst post 01/21/20,Last post 01/23/20Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry ove…Using Smartsheet243Gunn_Jack -
Accepted Answer Justin Runner 38 views 7 comments 0 points Most recent by Andrée Starå Formulas and FunctionsFirst post 01/21/20,Last post 01/23/20I'm looking for a formula to help me calculate the length of hours an individual has worked. Employees enter their "Haul Start Time" and "Haul End Time" manually by picking from a drop down list of times in 24hr format.…Formulas and Functions387Justin Runner
-
First post 01/21/20,Last post 01/22/20Hi, we are using Smartsheet's webhook API. We have the following use case. Consider user 'A' registered a webhook on a particular sheet. When some other Smartsheet user 'B' who has URL of the sheet of the user 'A' and tried to access the s…API & Developers221Anurag T
-
First post 01/17/20,Last post 01/17/20I have multiple sheets(Representing a job) in a workspace that have conversations. I am wanting to combine all of the conversations into one report or sheet to see all of them in one sheet. Can this be done?Using Smartsheet141rwholland -
*NEW: Proofing using ReportsAccepted AnswerAccepted Answer amontemayor 43 views 20 comments 0 points Most recent by BrianBosché Using SmartsheetFirst post 10/01/19,Last post 01/10/20The new Proofing capability is something we would like to implement in our department, but we are having issues with accessing this in Reports. We see that Proofing can be done in the main smart sheet, but our Artists access new design req…Using Smartsheet4320amontemayor
-
Save Button For WebformsAnsweredFirst post 01/08/20,Last post 01/09/20Hello Smartsheet, I have seen multiple threads from as far back as 2015 asking for a save button for webform https://community.smartsheet.com/discussion/1909/saving-coming-back-to-a-partially-complete-web-form https://community.smartsheet…Using Smartsheet221Jia Lee
-
First post 09/10/19,Last post 01/07/20We all love a Freebie? OUR API development team get lots of requests for automation which is the basis of our Smarter Mini Control Center 12 Apps, but one request we have been unable to fulfill so far (unless we use Appsheet with Smartsh…API & Developers2132Richard Rymill SBP -
First post 11/07/19,Last post 01/03/20My company is using a Smartsheet which uses custom columns fed by a request form. The purpose of this sheet is to process and track product enhancement requests, and occasionally we will migrate JIRA tickets into the process as well, whic…API & Developers322AllenG
-
First post 06/15/17,Last post 12/06/19Hello, Is there a way to rename a report through the API? Thanks, NathanArchived 2017 Posts264Nathan Reid
-
Closed Isidor Flavio Graf 28 views 7 comments 0 points Most recent by Paul Labedan Archived 2017 PostsFirst post 01/03/17,Last post 12/06/19Hi, We have a lot of reports, they have only small differences. Normally it is just a filter e.g. name of "assigned to". If we have to slightly change these reports, we have to change all the reports by hand. Is it poss…Archived 2017 Posts287Isidor Flavio Graf
-
First post 12/05/19,Last post 12/05/19Background * We will be creating / managing projects in Smartsheet * Each new project is a new sheet, based on a template * I am designing integration to other systems that need to be notified whenever a new project or task within a proje…API & Developers351MOverholt
-
First post 12/04/19,Last post 12/05/19Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific location…Formulas and Functions352KDub618
-
First post 09/27/19,Last post 12/04/19I work with a small Real Estate company and we lean heavily on Smartsheet for all of our task and workflow management. We have built a system of task lists, workflows, and meeting agendas that all work very well, but at the moment we have …Formulas and Functions834Chann403
-
First post 11/28/19,Last post 12/03/19Hello, Am working with a company as an IT which needs a CMMS tool for their mining clients for the WR, WO, PMs, AMs and so forth. And I need an expert of Smartsheet to help me on contract to develop the tool for them.API & Developers252Peter Kafui Doviavu
-
First post 12/02/19,Last post 12/02/19I have created a python script in PyCharm, the file has been running with no issues. I converted the file to .exe using PyInstaller and auto-py-to-exe but with both methods I receive the following error after running the .exe: "Impor…API & Developers410Tristan Falcon
-
First post 11/25/19,Last post 11/28/19hi team, I need help with removing the overheard data from the Smartsheet api call that returns a json file, I need to remove all the overhead before putting the data into the pipelines, thanks. (Image)API & Developers221somer
-
First post 11/26/19,Last post 11/26/19Hi Team, Is it possible to automatically navigate to a URL added in a cell if specific cell value changes to specific value? Please see below to understand the requirement. I have a tracker sheet for each project. Each tracker sheet ha…API & Developers292amkumar81861
-
First post 08/23/19,Last post 11/25/19Hello, If I'm building a website, can I create a custom HTML form and get the data into Smartsheet somehow? Smartsheet's native forms don't have the capabilities that I need (conditional logic) and I would like to make my forms a bit pret…API & Developers607pnc51
-
First post 11/15/19,Last post 11/21/19Hi all Anyway to get the row # from a cell value and use it in a formula? Example this works: IF(COUNTIF([Assigned To]$974:[Assigned To]@row, [Assigned To]@row) > 1, "DUP”,1) Now let's say Column1 row 23 contains the value 974…Formulas and Functions161djpreece
-
First post 11/07/19,Last post 11/15/19While the header of my question seems confusing, hopefully an easy solution exists somewhere. I have a complex smartsheet's dashboard created which has metric widgets filled with values that update every time a new form is submitted to …Formulas and Functions295austinurbanSeagate -
First post 11/14/19,Last post 11/15/19Hi All, I am attempting to automate the creation of my Agency's Organizational Charts via Visio and the smartsheet ODBC connector. We have our "reports to" information stored in smartsheets and have used the ODBC connector to c…Premium Apps and Integrations191C_Carroll
-
First post 11/11/19,Last post 11/13/19Hi. I'm trying to update a cell on a row which is a data field using the C# api. However, I'm getting an error {"Value is not supported for this column type. Use objectValue instead."} But when I'm trying to set objectvalue i…API & Developers141hanemay
-
First post 11/12/19,Last post 11/13/19Hello all - I am building a dashboard and wanted to include a few charts. However, my charts come up fuzzy, regardless of size. See below. These are pretty nicely sized on my dashboard and still showing blurry. I saw from a post in N…Using Smartsheet202SophieKelly1
-
First post 11/11/19,Last post 11/12/19For example I have sheet A that has my master list and all components within a "Kit". On sheet B I have multiple kits and would like to reference all the included components. I get that you can link cell to another just like an…API & Developers322Dean Sund
-
shekhar.kanade109651 23 views 2 comments 0 points Most recent by shekhar.kanade109651 API & DevelopersFirst post 11/01/19,Last post 11/11/19Hi All, Raised two cases with Support but no response so starting new discussion. We have created smartsheet webhook with callback url having port 443, 8008,8000 and 8080 but able to get response when callback url configured with 443…API & Developers232shekhar.kanade109651
-
First post 11/05/19,Last post 11/07/19Thank you in advance for any help you can provide. Since the Multi Select Dropdown option was not around when we created our form, we used a variety of check boxes to gather the required data via a form published on our website. Now that…Formulas and Functions2383BKathy
-
First post 05/21/18,Last post 11/07/19Hi, is it possible to populate the contents of a dropdown list from another smartsheet?API & Developers28111HankBento
-
First post 11/04/19,Last post 11/06/19Hello, Currently Smartsheet doesn't allow me to send an Alert with an attachment. The context of this is for a travel spreadsheet, when someone enters their itinerary, it will send the person an email with a standard email containing an a…API & Developers312Oby
-
First post 11/02/19,Last post 11/04/19Hi! I'm trying to generate custom PDFs with a specific template from a smartsheet row. The workflow currently uses an automation to send an email when the row is "done". Right now, that email contains the "Row Number" …API & Developers211bcromie
-
First post 04/02/19,Last post 11/02/19Hi How do I automate the workflows in smartsheet for repetitive tasks? For example Scenario 1: The issue has been raised by Testing team - which goes to the Development team, they modify the code, Testing team tests the modified code -…Formulas and Functions385Asha Rajesth
