-
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…
-
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…
-
Formula Functionality: RYGB Status Change Based on Date
Hello! I have reviewed Smartsheet Discussions quite a bit, but this is my first post. I am trying to correct a formula I made to change RYGB statuses. Currently the status correctly changes based on the following: Blue if a Date Resolved is entered. Green if the # of calendar days is > or = to 15 days. Yellow if the # of…
-
Auto populating Rows based on the number in the Qty box
Hi. Is it possible to auto populate rows based on the number I have in my QTY cell? I want when I enter a 3 in the QTY cell it automatically copies and adds those three lines. I need each of the in this case branding # to have their own lines and I do not want to have to put in all this data. Sometimes we have up to 100 or…
-
Utilize Pivot App for cashflow from multiple milestones
I have a sheet that tracks milestone payments associated with a specific type of project contract. Each row is a contract and columns are payment dates or amounts (see screenshot below). There are up to 5 milestone payments for each contract resulting in 5 pairs of columns (date and amount). I was hoping to use Pivot App…
-
Digitally Stamping an Attachment
I am looking to see if anyone has come up with a creative way to digitally stamp an attachment without having to download, open, stamp, save, and upload said attachment. We have an approval process that goes through multiple steps and the final step is a stamp. This is a timely process and I am looking for suggestions that…
-
Group Rows in Sheet, not just in Report
I would like to view rows grouped by their category (from a dropdown column) in Sheet form, so that I can add new rows while viewing my data in an easier-to-read format. Currently it seems grouping can only be achieved in a Report which does not allow me to add new rows. I am new to SmartSheet but have intermediate…
-
Due Date alert
Is there a way to alert a user that he has a due date approaching either through the native app or slack? bob
