-
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…
-
Managing and Reporting on Multiple Projects Effectively
I apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocused on what I’m trying to do that I’ve missed it. I’m looking for a way to manage and…
-
Colors for chart widget not preserving settings
Hi all! I am fairly new to Smartsheet but have been taking training where I can to get up to speed. I'm stuck on one particular issue and I'm hoping someone can help. I set up a couple of donut chart widgets to track task status for a couple of sub-projects. These charts get data from a metrics sheet I set up. The idea is…
-
Locking in Colors for Charts in Dashboards (Avoiding category colors changing with dynamic data)
Hi, I am having an issue with Pie charts changing colors when data in the underlying sheets is altered. For example. If I have a pie chart with categories for task status: Not Started, In Progress, and Completed. Lets say I designate those colors Red, Yellow, and Green in the Pie Chart. If the underlying data changes so…