-
Referencing Multi-Select Dropdown in a Formula to Get Elements On One Line
Hey everyone, By default, if you a cell in a multi-select dropdown column with more than one option selected and then copy/paste that cell or reference it in a formula, each element is pasted on a separate line, like this: Is it possible to get all the elements on one line with commas, like this? Thanks!
-
How to create a conditional formula with date specifications?
How do I create a formula that counts the number of rows containing [STATUS] “Green” and have [DATE] = Today and [DATE] = Last Seven Days from Today. I do not want to capture rows that are older than seven days from today.
-
Marking Oldest 5 Projects
Hello! I have been working with some data and I want to eventually be able to pull a report of my "past due" projects and show the oldest 5 projects. To do this, I have created a helper column in my source sheet that using the formula: =IF(Date@row < SMALL(Date:Date, 6), 1, 0) in order to flag the 5 oldest dates in my due…
-
OR function Not Working with Multiple Logical Expressions
Hello, I have the following formula: =IF(OR(Status4 <> "Complete", Status4 <> "Sent/Complete"), "not complete", "Complete") which always returns "not complete", i.e. true. However, modifying the expression so that only 1 logical expression is present, the expression works correctly, showing the true and false outcomes as…
-
Forms - headings don't match Smartsheet column headings
I am new to the Forms in Smartsheet, and am trying to figure out why my form field tabs (words on it) don't match the Smartsheet Column Headings. For example: I have a question listed on my Form field and the space people can answer but in Smartsheet instead of showing the question, it says column 16? I do I change that to…
-
Are webhooks a premium feature in Smartsheet?
Hi All, I'm in the process of building an app that utilizes Smartsheet's API and I would like the code to run whenever a change is made to a particular sheet. In the API's documentation, it appears that "Event Reporting" and Webhooks are my two best options. However, Event Reporting is a premium feature that is not…
-
Dashboard Widget Chart Issue with Multi Select
I have a dashboard chart widget that was pulling data from a single select option. I've now changed it to multi-select but I see that my chart isn't pulling in that item at all when there are more than 1 item selected. Am I missing something? Is there a formula that I can use to pull in that single option + any combination…
-
Webhook callback authentication
i am trying to work with smartsheet webhooks. Would like to use the callback authentication feature as explained at http://smartsheet-platform.github.io/api-docs/#authenticating-callbacks-optional. However, the instructions are not very clear of how to calculate the HMAC value from sharedSecret and request body. For…
-
VLookup with IF statement
I am going to try the out of spec condition using VLookup. I am not sure this is possible. But here we go. This log has entries that will VARY but do have upper and lower limit specs. However, in the same stage one substrate may have a different u/l spec sujch as seen here with CRS UPPER limit of 175 and all others have…
-
Capturing a Total Count to display in a Dashboard
I am trying to capture the total number of active projects found in a specific Workspace. Each project is its own, separate, SmartSheet. The way I am able to do this now is by manually creating a Formula (COUNTIF({Proj Name Range 1}, "Yes"),in a separate SmartSheet, and then creating a Metric Widget within the Dashboard to…