-
Drop Down, and Auto fill cell wit color
How do you setup a cell which has a drop down menu with 3 selections YES, NO, and N/A What I want is: If YES is selected the cell will turn Green. If NO is select the cell will turn Red If N/A is selected the cell will turn Yellow Thanks
-
Lookup Cross Sheet Reference
I am having difficulty with writing a formula that will help me with cross-referencing two sheets for an inventory process. Sheet1 has numbers from a previous inventory date and Sheet2 has numbers from a current inventory date. The SKU in the column labeled Column1 in Sheet1 could also be in Sheet2. I have created the…
-
Setting formula to match dropdown list in columns (same row, same sheet)
Hello, I need help please. Is there a way to set-up a formula so that an item in a column with dropdown list will automatically select an item in another column with a dropdown list? For example, Column A has 1,2,3 in dropdown and Column B has 4,5,6 in its dropdown list. If 1 is selected in Column A, it will automatically…
-
"#NO MATCH" Error
Hi @Paul Newcome, I was using "COUNTIFS" formulas and they were working completely fine until today all of them are giving me an "#NO MATCH" error. Everything seems fine with the sheet and the formulas. Would you happen to know why this might be happening. Formula: =COUNTIFS(Status:Status, OR(@cell = "Requested", @cell =…
-
Automated workflow - duplicating a row within a same sheet and then change some cell values
Hello, Here is the purpose of my sheet, it is a task list based on an IT ticketing request system. The new tasks are feed with a form. I also have a dashboard and reports to track tasks per user from this task list. So here is my idea, in order for my team to monitor their productivity, one specific type of task needs to…
-
Need to extract Non-duplicate values
Hi, I'm in the need of extracting the Non-duplicate values in a range. I could able to achieve same in the excel (Formula =UNIQUE(A2:A16)). See the attached excel schreenshot. I knew Distinct function is a replacement of unique in smartsheet but it can be used within the other function and not working propery. Kindly…
-
If formula with number ranges
Hi can someone help me with my formula below. I would like the out come to be if the value in row (view265) is 49 or less to =1 if the value in row (view265) is 50 or more but less then 200 =2 if the value in row (view265) is 200 =3 =IF(VIEW265 <= "49", 1, IF(VIEW265 >= "50", 2, IF(VIEW265 >= "200", 3,)))
-
Status Formula based on Date Range
Hello - I need help with a formula for a status column based on a date range (start and end columns). Status options for the formula include: Not started, Live, Completed For example, is the item has a date range from 2/21/23 to 2/28/23, the status should automatically change to "Live." If the dates in the date range are…
-
Formula for %Complete Column (or progress bar) for 5+ Checkboxes columns
Hi! I am looking for a formula to either give a percentage complete or similiar from a number of checkboxes. I have tried; =COUNTIFS([T1]@row1]:[T7]@row1],=1) - results in UNPARSEABLE =COUNTIF([T1]2:[T7]2, "True") / COUNT([T1]2:[T7]2) = 0 =COUNTIF([T1]2:[T7]2) / COUNT([T1]2:[T7]2) = incorrect argument set
-
permissions
Hello. I need help. I want to prevent anyone other than assigned to, which is assigned to a row in the created sheet, from taking any action. I don't want a locked row to be changed by any user allowed in the sheet. In other words, everyone can take action for the part that is assigned to in the line.How can i solve this.
