-
Using values returned by formulas in other formulas
Hi, I have a user populated field (using a dropdown) where the options range from “1-Innocence” to “5-Excellence” – this makes more sense to a user than simply having a 1-5 available for selection. To summarise these ratings per theme, focus area, assessment, etc. I obviously need to make use of the 1,2,3,4,5 values in the…
-
Multiple forms with unique dropdowns
Hello, I currently have a smart-sheet that gathers data from multiple vendors (each vendor has a form). One of the columns is an ID which would be entered through a drop-down. The functionality we are looking for is to have unique drop-downs for every form. Would this be possible? When I plug in the values for the…
-
Formulas in sheets with auto-number columns
I have a sheet with an automatic numbering column. Data for this sheet will be captured through a webform. I need certain columns, which will not be populated throught the webform, to have formulas in them. How do I add those formulas without adding them in the first row which triggers the automatic numbering? I thought of…
-
Emailing form submitter
Similar to this request (https://community.smartsheet.com/discussion/comment/179166) but is it possible to start an email chain instead of sending one email?
-
COUNTIF(S) where items are NOT equal to more than one value
Hello! I am trying to create a formula which counts all items that are NOT assigned to a list of about 8 people. These will be totaled into an "Other" field. Example: PMs include Bob, Sarah, Dee, David, and George. I have counts for how many projects are assigned to each of these people, no problem. Then I have a bunch of…
-
Smartsheet re-opening automatically after hitting submit
Is there a feature that would allow a SmartSheet form to automatically re-open with a new form after hitting submit? we are using a form for each caller and it is cumbersome to hit submit and then find/click the link to open a new form.
-
Validations/checks before changing the status of a row
Hello, First of all thanks in advance for support. I have a question, which i think is basic.... but i haven't find the way to solve it. I have a sheet with a status column, then i have 2 columns for KPI values: Status, KPI1, KPI2, start date, end date, etc.... I want to "not allow" to complete the task if the columns with…
-
Capture metric each day and add to new row
I have a number of Harvey ball metrics (count of red, yellow, green tasks) and things that change every day. I haven't really seen any way to capture and store these each day at a particular time (or hourly, weekly, monthly). Anyone have a good solution for it? Example of metrics I'm collecting on-the-fly from Control…
-
Reporting and Dashboarding on Multi-Select Column Type
Hi, bear with me as I am a pretty new user to Smartsheet (love the tool so far but have hit a snag) I'm currently utilizing the multi-select column type for a few of the sheets I'm working on. I love the feature, but am having trouble building the exact dashboard I need to report on my multi-select column. Let's say I have…
-
Is it possible to escape special characters in dynamically added cell data in request messages?
I would like to build a link to a Smartsheet form from another sheet's workflow, including default values as described here: https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values Those default values should be set from a cell using {{ }} as described here:…
