-
Inventory Formula Question
I am trying to keep track of items we have to give out to community members. Mostly I am just making sure I know when I'm getting low on a certain item. I made two sheets, one with the name of each unique item and one with more details that allows me to keep track of the person and date the item was given. Those details…
-
Logic not working properly.
I'm trying to add 5 different logics. If question number 2 "does not contain" 24, 23, 22, 21 or 20 I want the error box to come up. I enter in the first logic step and it works, once I start adding more it stops working properly. Now, when ANY number is entered for question 2 the error box appears. What am I doing wrong?…
-
How to use IF
This might be simple, but I am a beginner. Team members will be pasting one of these 10 cities/counties into the Area column and selecting either “Experimental” or “Written” in the LOB column. I want their choices to automatically populate words into the District Column. Some have a 1 to 1 relationship, others have a 1 to…
-
Help Article updates
Hello Community, We’ve updated the API Limitations article and added an AI page to help you learn about artificial intelligence tools in Smartsheet. To view the full catalog of help articles, visit the Help and Learning Center. Were the articles helpful? Let us know by providing feedback at the end of each article.
-
task cut
Hi everyone, I'm trying RM and I have this situation: Task1 has been programmed for User. While executing task 1, an urgent task (2) has been assigned to User. So, User needs to stop Task 1 and suspend it for a period. Must give priority to urgent task (2) How can I handle this in RM? Is it possible to cut the activity? It…
-
Collect value where cell with multiple value options contains a specific value
Greetings, Community! I am hoping someone can lend a hand here, as I have tried multiple options but keep coming up short on a solution. Essentially, I have two tables. Table A (Names) has a list of unique names. Table B (Events) has a list of events, where each event can contain multiple names in a cell (not contacts,…
-
One Conditional Formatting Rule Not Taking Priority
I apply a similar strategy of conditional formatting to a lot of sheets and don't usually have any issues, but on this one sheet, I have a rule that's listed above the others, but it's not taking precedent over the other formatting rules and I'm not understanding why. I have a cascade of blue colors to denote "header"…
-
Help with Global Update for rows added across 2 columns already updated on master sheet
I added 5 rows of data (across 2 columns) on one sheet of our current control center template and want to do a global update to edit all our workspaces. I was able to do GU for the new columns i added but don't know how to do same for new rows. One of the new row cells includes a formula as well. When i select the modify a…
-
Help with a complex Mutli Select Drop down formula!
Hello! I have a sheet which is connected to a form where the user can enter what services will be required (as a multi select dropdown option). What I want to be able to do is reference another sheet that has a 'practice' (line of business) that the service is related to and return all those values inside a second drop…
-
Copy Rows to another worksheet automation not working
hello, I'm trying to create a workflow that copy rows into another worksheet using automation however, I do not see my selected destination worksheet I have admin roles in both worksheets and i'm not sure why i couldn't see my reference worksheet in the search box as my destination file. can someone help how to fix?
