-
IF Statements with two different Columns
Hello, I am trying to write a formula to state if this date is greater than XX, and a different Column = 2, then give me a 1, if not then 0 but I can not get it work. =IF([Install Date]@row > DATE(2022, 9, 23), [Mashgin Qty]@row = 2, "1", "0")) Breelyn Brown
-
Donut Chart - How to automatically color red, yellow, green?
Hello, I've created a donut chart that shows a score as a fraction of a total score. I'd like to have it automatically color the score portion red, yellow or green based on a range of the score to the total. Excel does this using donut charts and formulas. How can I do this in Smartsheet? I was able to color it…
-
update requests
Hi. I've set automation on a worksheet to send an update request on completion of a form - users all have the same permissions and the access is set to unrestricted. There are a couple of issues: 1) not everyone is receiving the update requests 2) for some who DO receive the update request and respond, their response is…
-
How to create reports according to the Month
Hello Everyone, I hope all are doing great I wanted to generate a report which is getting data from multiple sheets and its primary column is Months so according to the months, I am creating the report/chart. Now, the problem is I want to create a graph for this which shows the current month and then the next 11 months.…
-
Sharing with Free Collaborators - Sheets vs Templates
From what I have found, if I create a template a free collaboartor cannot use them. Is it just better to share sheets with them instead? I have a set of intake, metric sheets and dashboards others would like to use in their departments, but we do not have an Enterprise account, therefore they are not licensed. If I share…
-
IF Formula issues
I am essentially trying to combine 2 stoplight conditions into 1. I'm trying to have the formula express that if both the Min and Mix column are gray, then populate a gray dot. If either column is red, then red dot. And finally if both columns are green, then green. Is this possible?
-
Converting numbers to text based on range of values
Hello, I am trying to create a formula to convert the following values to text based on the ranges below: I created a separate sheet to reference the scoring ranges and incorporated that into the formula below. Here is the formula I attempted to use but am getting an "Invalid Operation" message" =IF([What Numeric]@row <…
-
How do I search for questions I've asked in this community?
I entered a question yesterday, yet I can't find it searching the topic or my name, or even browsing through the questions over the past day.
-
Find (CTRL+F) Values in Contact Column
It appears impossible to find values in a contact column using a CTRL+F/Command+F find function. I've attempted searching by the contact name (Joe Smith), contact email (joesmith@company.com), and even the messier value that copies and pastes out of a given contact cell (Joe Smith <joesmith@company.com>). I need to find…
-
Removing an option in dropdown, if selected
Hi Smartsheet Community, I am currently working on a form. The form has 2 dropdowns with the same options. Is it possible to that if I choose the option from dropdown 1, it will be removed from dropdown 2? Thanks in advance!