-
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:…
-
Creating an At Risk Formula
Hello Community, I am trying to create a formula that will create a flag if the tasks are not marked as Completed in the status column and the Due Date has been exceeded by 3 days. I've had nothing but headaches in trying to figure this out. I would be very grateful for any assistance you can provide with the IF formula…
