-
Notifications
Is it possible to set up notifications to let someone know RIGHT AWAY when they have been assigned to a task thats in a sheet they're shared to? I'm trying to avoid individually sending update requests in the beginning, and I'm trying to avoid sending everyone shared to the sheet a notification about a task that doesnt…
-
NEWBIE: Smartsheet Feature Relationships
What is the difference and hierarchical relationships between "sheets", "workspaces", "folders", "sights" and "dashboards"? As a marketing director, product / project manager I am just trying to figure out a logical build sequence for my new smartsheet content. Sheets and folders are pretty straightforward, but what is the…
-
Sales Pipeline Sheet information links to Project management sheet upon status change
Our company tracks sales opportunities and basic project management using Google Sheets. We would like to move this function to Smartsheets. Our basic process: (We design, fabricate and install elevator interiors) A new sales opportunity is logged into a googel sheet and given a status of "Bidding". We also input several…
-
Multiple dropdown list driven by previous choices
How would you set up a dropdown list that is driven by the selection in a previous list. Example: column one has ten property's to choose from, column two is a list of locations specific to the property that was chosen in column one. Chosing a different property in column one changes the list to choose from in column two.…
-
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…