-
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…
-
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!
