-
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…
-
How can I calculate the percentage a resource is allocated to each project?
How can I calculate the number of days or allocation percentage a resource is assigned to a project? What I'm trying to understand is the percentage a resource is allocated to a project so I can track the total in a master project list. For example, if a resource is assigned to 3 projects and they are aloocated 25% per…
-
Suggestion for comments area
I have a settings suggestion. Mouse over comments would reveal the whole comment so i don't have to click on it to read it.. Make it a user preference. Thanx!
-
Notifications - Summary of changes in Email
Is there a way to send out a notification update that will either include the exported attachment of the sheet or just a list of the recent updates in the body of the notification email. I would like to send out an update to a large audience that do not have license or access to smartsheet, but I want to make it easy for…
-
ODBC connector setup on MAC
Hello Smartsheet Any news on a possible setup to allow MAC users to configure connectors between Smartsheet and Excel for example? thank you Jan
-
Saving Smart Sheets in storage
I hate having all of these smart sheet tabs. Is there a way to export them to a smart sheet format in another directory? I dont want to save to excel or any other format. I just want to hide my smart sheets off my tabs. Thanx!
-
Prepopulate a webform - Automatic Submit
I'm able to populate all the fields in my Webform by including the field details in the URL, Is there a way I can automatically submit this webform ? I'm trying to get data from a 3rd party package across to smartsheets without having to dig too deep into the API side of things. Thanks in advance.
