-
Interested to hear from people who have/plan to use Smartsheet as a Facilities/Maintenance System
Hello all, I have been using Smartsheet to help my clients digitise their Cleaning / Maintenance / Landscaping / Service processes and businesses. This includes Site/Location/Asset lists, service request and reactive/planned work tickets. I have created a solution that allows Services Requests come in via forms, get…
-
ColdFusion and SmartSheet API
0down votefavorite I'm attempting to call the smartsheet.com api and read the JSON data from a list sheet request. Im new to API's so I'm certain I'm missing much with my code. Here is what I have so far: <span class="tag" style="border: 0px; color: #7d2727;"><cfscript></span><span class="pln" style="border: 0px; color:…
-
Call Center
My new challenge is building a service dispatch system within Smarthsheet. I have wanted to do this for a very long time. I am attempting to get alot of information into the sheet and would welcome any help. Im looking to make it like an airport type screen. I am trying to get: * Schedule * Ticket # (CSR#) & Details *…
-
Convert date format to mm/dd/yyyy
Is there a setting or a formula to convert the standard yy in smartsheet to yyyy?
-
I'm looking for a way to calculate time of day based on predecessors.
I have a very specific need to a time intensive schedule that requires time of day (TOD) to calculate based on predecessors. Currently I have been manually entering TOD of Start Time and Finish Time in general columns but would prefer these to be formula driven. Has anyone done this?
-
Warning and suggestion: Backup doesn't include links (URLs) to attached external files (GoogleDrive,
Hi, Regular backup tool (https://help.smartsheet.com/articles/506499-backing-up-your-data) has severe data shortcoming since it doesn't include links (URLs) to attached external files (GoogleDrive, Evernote, etc.). So, users can't recover their full linked attachment based on Smartsheet backup. a) The backup documentation…
-
API: Copying only specific columns within a row
I want to copy a row from Sheet A > Sheet B. Sheet A contains several columns that Sheet B does not. Currently, moving the row results in Smartsheet automatically creating the ommited columns in Sheet B and dumping them at the end. Is it possible using the API, to select only the columns I want to move? Or to somehow…
-
Counting non blank cells in a row till first non blank.
I need to count blank cells in a row, left to right, till first non blank cell. the non blank cell may contain any character/s or digits. Any suggestions? For instance this formula will work to count blank cells till it finds X in row 1, columns 1-20, but not anything else: =MATCH("x", [Column1]1:[Culumn20]1, 0) - 1
-
Download files from webform?
We would like to have a webform that essentially worked like a standard 'terms and condition' agreement, where the user would enter their details, agree to the terms, nad then be able to download a file(s). The webform then creates a register of anyone that has downloaded that file. Is this possible using , Smartsheet or…
-
Word Document - Smartsheet Preview
Is there a way to preview a smartsheet that has been published within a word document. For example, say I want to include a list of contacts within a document but the contacts could change, rather than updating my contacts in the document and in my smartsheet I want to just update it in smartsheet and feed it to the…