-
Trouble creating exact match formulas to list tasks associated with specific departments.
I'm working on a set of formulas that will find the tasks and list them for the exact matches of the below Department names (among many others). I' have a formula that will work for a few of them but not all of them. As you can see they have similar letters (EDI and IT) and the results they return overlap each other, or…
-
Allow automation to populate cells with formulas.
For some reason the devs have blocked using =formula() and they populate cells with '=formula() when you try to use the features in conjunction. This makes your formulas inert and is quite frustrating. This seems like such a easy way to increase efficiency in the program and should be implemented immediately. Thanks for…
-
If name in this column, put contact in another cell but not the cell with the formula
I'm using the Jira Connector and having a heck of a time getting contacts to sync. I've been through a laundry of ways so now I want to try this. I'm able to bring in the Assignee Display name with no issue in a text column only. Jira connector will fail if a column has a formula (so frustrating, let me tell you!), so I am…
-
Is there a way to set up a SUMIFS formula that will ignore the search for criteria if needed?
I need to set up a SUMIFS formula based on 5 pieces of criteria Business Category Brand Product Name Customer However, is it possible to set up formula that would ignore the need to search for all 5 criteria if any of the criteria are blank? For example, if I wanted to the sum of all products for a specific customer…
-
Formula to SUM = 0 Why?
I created a formula to sum the values in other formula columns but the return is "0". I have created other sheets with the same type of formula and the return is correct. How is the return 0 on this formula. It appears to be correct.
-
Formula Help - Rank to be able to use on reports
Hi All, Just wondering if anyone can help me with your wisdom! From the list of assets below, I need to have top 5 or top 10 of most ordered as well as less ordered (please note there is a repetition of the same asset name throughout the sheet) and there's 2 x different categories: social and TV which need to be ranked in…
-
Formula Help
Hello, I feel like I am close with the current formula I am using in a build out. Could use some help if anyone has suggestions. I have a section where AutoFail is possible and then a Section that is Pass/Fail based on %'s. If they Pass the Pass/Fail Portion but Auto Fail the other portion the entire total score is Auto…
-
Dashboarding a specific cell
Hello all, I have a smartsheet set up to calculate an inventory as items are added and subtracted via a form. I want to dashboard the current total of the item. This is the top cell of a column. I can't get the top cell to display, as when I link the cells, it displays the old cell when a new one loads in. Any thoughts?
-
COUNTIF formula help
I'm trying to create a formula that will count if a specific value is in a cell and the formula works as long as the cell only has 1 value in it. But I have some cells that contain more than 1 value, how do I get it to work for those cells? Ex) There are 4 cells with the word Red. 3 cells with the word Blue and 3 cells…
-
Assigning Score to Multi-Select Dropdown Menu Options
Hi, I need assistance with assigning a score for outputs using a multi-select dropdown menu. Essentially, I want to be able to assign a numerical value when someone selects a choice from a multi-select dropdown, however, I am only able to assign a score for one answer. When multiple options are selected, the IF formula I'm…
