-
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…
-
Min/Max Time Formula
I am need to calculate the min and max time for a column. These times are entered manually (from forms) in the HH:MM format because created by and modified by columns are not appropriate for the purpose here. The times are entered into a form. These times are converted in a new column using the following formula:…
-
Formula for adding value to column in one sheet if reference is made
Looking for help with a formula! I have 2 sheets - Production Workforce and Production Totals. We work by job numbers, so would like to have the calculated workforce days from "Production Workforce" appear in the "Production Totals" sheet if a job number reference is made. Any ideas?!
-
Formula with CHAR(10) and multiple references
hello, I am working on a formula to combine all notes from multiple PMO discussion groups. I have it working but in my Master notes column if a discussion group left information blank, the CHAR(10) puts large blank space within the column. Each discussion group is grouped together within the below formula.…
-
Concatenate/Roll Up Text in Children Tasks
I want to rollup all of the updates made in the children tasks into the parent row. Is there a formula that can do that? Here is a screenshot of a parent row with some children tasks. The column with the updates is called 'Updates'. Can anyone help me create an IF statement that accomplishes this?
-
INDEX/MATCH/MAX Formula within a date range
Hello Smartsheet Community! I am helping our team report on an individual who requests the most deliverables within a date range. Meaning, if Ted Williams requests the most deliverables in Q4, Ted Williams should show up in the report based on the countif/helper column. Below is the formula I've been working with based on…
-
Checkbox for Unique Item Name
Hello! I'm trying to create a formula for checking a box for only the first instance of a unique value in the column "ITEM NAME". IE it sees the first instance of "Event Case 1" and checks the box for only that row, and the remaining instances don't get checked. I tried using the AI tool but the formula it creates can't be…
