-
Viewing pictures in Dynamic View without having to download the file.
There needs to be a way to view pictures and attachments in Dynamic View, like in sheets, without having to download them every time you want view them. I'm sure that Dynamic View was added after basic sheets and can't imagine why this functionality would be set up to force a download. This is the only function keeping us…
-
How to divide single request with multiple contacts to individual requests.
Does anyone know how to take a single line, with a single multi-select cell, and have that line parse/delineate/divide in to individual lines, either through a formula or an automation? Scenario: we are receiving schedule block request for team, and multiple people may be on the block request, therefore we have multiple…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Current User System Field
System Field that captures who the current user is so you can use formulas or logic based on that.
-
Hyperlink for mailto: in Reports, Dashboards and Grids
I've seen this topic come up a few times now, but couldn't find an enhancement request submitted. It would be nice to have the ability to link email addresses in Reports, Dashboards and Grids. The dynamic contacts in Smartsheet is a nice feature turning email addresses to a standard First/Last Name, but could we add the…
-
Dynamic Data Validation with Columns from another Grid
Hi, I want to be able to validate data in a drop-down menu in one sheet from a column in another sheet. EX: I have a sheet that serves as a master sheet of projects and the project's properties (Name, budget, etc.), and another sheet that serves as tracking tasks related to the projects in the master sheet. When People…
-
Help with IF(INDEX(MATCH
Hi all, First question in the forum. I'm in need of help with an INDEX(MATCH( formula that I've been using but now need to make conditional on another column. Essentially, I only want the INDEX(MATCH( formula to return a value when a column "Completion" is changed to "100%". I've tried nesting the existing INDEX(MATCH…
-
Edit Start, End, or Duration from Report
I'd like to be able to edit the Start Date, End Date, or Duration of a task from my report. At present I can only edit Start and Duration from a report because End is treated like a formula. This is problematic when I need to adjust both dates because it forces me or another user to do math (accounting for non-working…
-
Hello from Biotech
I work in Regulatory Biotech and started using Smartsheet to summarize our Global Submissions data to the Global Health Authorities. Look forward to Smartsheet updating the functionality of charts!
-
Version Control/Backups That Maintain Cell Links
I have seen some posts referencing similar pain points, but thought I would try to distill it into one idea post: Smartsheet is awesome at so many things, but one place where it lags behind other cloud productivity solutions is in its ability to backup, back rev, and implement version control. Yes, you can view history on…