-
Feature Request: Notification of lock/unlock of rows/columns to sheet owners
For the sheet owners who share sheets with admins so that they can edit locked cells, it would be good to know when the Admins are locking and unlocking the rows/columns. If they mistakenly unlock the columns, this overrides the controls put in place by the sheet owner (me). So, please create some form of notification for…
-
Photo image size when importing via Web Forms
Hi, Using a “Web Form” to import an image or take a photo adds the image to the attachment column in the row. And the average picture size from my iPad is approx 1.4 – 2.0mb. Now taking the very same picture via the "iPad App" using, Edit Row / Select Camera Icon / Take Photo… Inserts the picture “resized” into the cell.…
-
countifs with specific data set and dates
I have a column with specific criteria (Sample type) and date column. I have another formula that looks specifically for a "sample type" and specific "factory". The formula I've used for this is: =COUNTIFS($Program$3:$Program$333, "Fall Tabletop / Decor", $[Sample Type]$3:$[Sample Type]$333, "DEVELOPMENT + ARTBOARD"). This…
-
Emailing Sights
I can't seem to find a way to send a Sight as an attachment like you can with reports, is this possible? I need to be able to send sights on a regular basis. This feature would be so much better than having to take a screen shot and attaching it to an email.
-
Web form question
Does anyone know if the web form functionality will incorporate a slide bar rating scale? This exists in Surveymonkey and my Marketing team still uses Surveymonkey regularly because of this feature vs SmartSheet web forms. thanks!
-
Tracking of RYG Status changes
We have a fairly complex sheet that we use to track survey requests between us and one of our clients. One of the columns is a Status indicator using RYG balls. Both us and the client collaborate on the same sheet. We use it as follows: Green - Survey on track and continuing Yellow - Issues on the survey that must be…
-
Clone Columns including Conditional Formatting
I have a Smartsheet that shows the status of an item by date and I'd like to be able to copy or clone the column with all the conditional formatting. Is there any way to do this?
-
COUNTIF substring or wild cards
I have a column of Part Numbers. Each cell in the column may have a single part number or comma separated part numbers. I want to count the number of occurrences of a particular part number in the column. I searched the help and community pages but wasn't sure what's the latest. Is it possible to use wild cards or any…
-
LOOKUP & MATCH together
Hi everyone, I use a VLOOKUP and MATCH function in Excel to find the intersection of vertical and horizontal values (intersection of a matrix / table). I can't seem to get this working in Smartsheet and need some help. For example if I have Likelyhood = Likely and Impact = Moderate then I want the Criticality to return the…
-
Feature Request: Timeline within Smartsheet
One feature that MS Project had that I've had a hard time working around is a timeline feature that is part of the application. I understand that SS integrates with Office Timeline, but I have to pay for this, manually manipulate this, and I have to recreate a timeline each time deliverables change on my plans. We have a…
