-
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?
-
Formula previously working (along with others) and not now
Hi all I have this formula in one of the summary sections for tracking the SLA of job completions as part of a number of others, mainly for the creation of graphs and percentages etc and a lot of them seem to have stopped working. They now say #INCORRECT ARGUMENT SET. None of the references have changed and I'm so confused…
-
I Need Help with IF Formula for Progress Bar Symbol Column to Function Accordingly
I'm trying to set up our Carpentry Shop's Progress Bar by how many hours they've used from the total hours they were assigned to use for the project. The following screenshot shows an example. The carpentry shop was assigned a total of 80 hours to use. So far they've used 40 hours. The progress bar's formula then updates…
