-
Random assignation
Hi, I'm trying to assign a task to one of my team members (there are four). Every time a new project is added to the queue, instead to manually add one of them, i would like one randomly chosen person among them four. Can you please help me to get this? Thanks in advance! Alberto
-
Have a column with different values and trying to create helper column to assign number
Have a column where freeform module numbers are entered (i.e. 101, 204, 300, S811). I want to create a helper column, where it will read the module number and assign a single digit. (i.e. 101, 104, 141, will all return "1" in the helper column and so on)
-
Creating a Formula to Return Conditional Values
Hello! I'm novice when it comes to building formulas and am looking for guidance on essentially copying my conditional formatting to return values instead of highlights. I am tracking missing trainings/policies and want a cell to return a value from a dropdown menu if a training is missing or past compliance. The tricky…
-
Formula based off Checkbox selected
I am looking for the formula that would return values from another sheet based on the checkbox being checked. I have a data sheet, which contains predefined hrs and rates for a specific deliverable. In another sheet I want to these values pulled into once the checkbox is checked. please see 2 pictures. E.g. if I check the…
-
Is there a way to make a field in a form auto populate street address as its being entered?
I have a shipping management Smartsheet that has a intake form with a address field. When users fill in the address field sometimes they do not provide the entire address. I want the address to auto populate as they type in their address.
-
NETDAYS Formula Question
I have created a formula to track in progress orders by the number of days, =NETDAYS([Date Received]@row, TODAY()) I have the following columns created, Date Received, Date Completed, In Progress Days This is a formula attached to the entire column, but I need cells for orders completed to stop counting as in progress. Is…
-
How to return the last recorded date in a column?
I have a % Complete column and a deadline column. I'm trying to write a formula for when [% Complete]16 equals 100% it returns the last recorded deadline. I'll use this to record the end date of a project. [% Complete]16 is the bolded cell which is averaging the children. The deadline that should return from the formula is…
-
Removing duplicate Material Requisitions (MR #) when counting
Hello, I am trying to count the number of requisitions (MR ‘s) per shop, minus duplicate MR's. Duplicate material requests equal one transaction (i.e., "1234" listed multiple times in a column still only equals one transaction). The MR # applies to multiple parts, thus the need for multiple submissions but still only one…
-
Check A Box When A Value On Another Sheet Changes
I have a sheet that is pulling data from a second sheet. What I want to happen is when the status changes to RECEIVING COMPLETE on the second sheet, it checks the box in the received into stock column. The problem is that once that status is updated to that value on the second sheet, it's moved onto an archive sheet that…
-
IF formula for INDEX/MATCH across sheets
Hi, I'm really struggling with this one. I have a sheet that has a drop-down with options for "Yes" and "No" and I want to perform an INDEX/MATCH function based on another cell in that row, but only if the result of the drop-down in that row is Yes. The sheet reference for the Yes/No drop down is {App_S}, and the two cells…