-
Update Hyperlink File Path
Hi I am working on a project that has now been completed. We used a series of hyperlinks to link to key documents. As the project has now finished the files have been moved from a working folder to a final folder with sub folders remaining the same. This means all the hyperlinks within the data base are now 'broken'. As…
-
vLookup: column name instead of number
When using the vlookup formula, is it possible to indicate the column name that we want to return as result instead of the column number? Cos sometimes the columns get reordered, and the results returned by column number will not be the intended column. This is especially so when we are referencing another sheet in the…
-
see workspace size when backing up workspace
It would be useful to see the size of a workspace, especially when backing up the workspace. The largest, the longer it takes to get the backup file. Thank you.
-
Lookup Functionality
I want to allow users to simply type in a lookup criteria, and see one row for the response that gives them the information they need versus scrolling through an immense database. I have had to create multiple complex Smartsheets with formulae, and then overlay reports and a dashboard to mimic this functionality. I would…
-
URLs for Templates
I have a few sheets that I saved as templates for other team members to use. I wanted to make the templates accessible from a dashboard by adding a shortcut to take users directly to the template preview so they can view it and choose to use the template.
-
pull data from Resource Management directly into the linked sheet/sheet summary
Would like a way to connect the project summary data in RM (project budget, incurred hours, future scheduled hours, project budget (fees), incurred (fees), future scheduled (fees) (see screenshot) into the linked smarthsheet/ smartsheet's sheet summary field.
-
Allow Document Mapping to be used across sheets
I have many reports that I map for generation that reside in different sheets. This requires me to map the reports for each sheet. If there was a general location, or a way to set as templates to use in any asset that would be such a time saver.
-
Deploy Smartsheet Desktop App Updates via Enterprise Software Deployment
We recently made available to our organization the Smartsheet Desktop App. In our organization we do not have Local Admin privileges on most users' workstations. It came to our attention that the Smartsheet Desktop App will not auto update itself without prompting the user for a local admin account. We use SCCM as a…
-
FIX Required: Last Modified Date + TODAY Function = updates all rows
Hello Smartsheet community I would like to see a fix. When you use the "TODAY" function anywhere in your sheet, ANY changes will update the "last modified date" for all rows. What I want: Only update the individual row that has changed. Why? So I know when (and who) made the last change. This was verified as a problem by…
-
Remove vertical whitespace in calendar views
We need a way to remove the vertical whitespace in the Month view of the Smartsheet 'standard' Calendar view and the Calendar App view. In the screen caps below, the red arrows show the whitespace I want to remove. The whitespace in the Calendar App view is more of an issue because the Month view in the app, due to all the…
