-
Generate Random Lists
Is there a function/formula that can take a list of names and randomly assign them to groups? Example: If I have 20 individuals that I want to assigned to groups of 4: Group A, Group B, Group C, and Group D Column 1 has list the names of the 20 individuals Column 2 is the output field for where the formula would go to…
-
I'm just stumped on this date function. Can someone help me please?
I have a sheet that is tracking projects for our team. I have one column that is "Asset Due Date" and I want another column "TD Due Date" to auto populate a date that is 28 days prior to the date chosen for "Asset Due Date". Both columns are set up as date column types. I've played with the date function and just can't…
-
Flag duplicates with conflicting dates
Hi, I have a list of names with a starting date and a finishing date. I am trying to get a formula that flags conflicting dates for the same person (duplicate). On excel I sorted with a SUMPRODUCT that I know smartsheet does not support. I have also tried to break it down so it adjust to smartsheet but I can't solve the…
-
Formula to identify with min/max date if column is less than 1 and date is less than today?
how do I do this? I have the below which grabs the count correctly for anything less than 100% and <= today's date, but I want to grab the min and max date. =COUNTIFS({Estimating Percentage}, <1, {Est Start Date}, <=TODAY())
-
Why is my formula #UNPARSEABLE
Hoping someone can help... I am trying to get a count of projects opened and closed based on week number and year. Range two below is the year column in another sheet (the column I'm starting with is 2022, but I will be expanding through 2026 once the formula works). Range 1 referenced below is the week number, as…
-
Error calculating time
I believe I have read through every thread on this topic and it has been extremely helpful. However I'm getting a weird error that hopefully someone can help me with. I'm getting a completion time of "10:05 04pm" in row 3, I'm sure this is due to the amount of time for the task - I just don't know how to write this so this…
-
Using COUNTIFS with multiple criteria and OR
Hi, I'm trying to count the number of rows that meet the following criteria (I'm getting an "Incorrect Argument" error. Project Complete is not checked Project Cancelled is not checked Sales & Leads is not checked Month is August Year is 2022 Deployment Type is either New Deployment or Package Upgrade =COUNTIFS({Project…
-
Report to show last data entry only
Good morning, I am looking for a report to return a column value from the last sheet data entry. Essentially, I would like to create a dashboard that tells me whether my machine is online or offline based on the data that the operator puts into the highlighted column. I'm guessing that generating a report would be the best…
-
If function with dates
Hi Experts, I'm trying to create a formula which should give me a Date as result. I have 2 check boxes and depends what it's clicked I would like to get the date below as results. If HALO Calendar is not clicked than DATE DATE(2022 / 8 / 26) IF HALO Calendar and Virtual Model CR1 is clicked than DATE(2022 / 10 / 13) If…
-
IF AND Formula Help
Hi everyone! I am hoping you can please help me. I have tried IF AND, IF OR, and IF CONTAINS formulas but nothing works. Referencing the below screenshot, I have a checkbox in the column titled "Carry Forward". I want to have the check box checked when the column titled "Vacancy Status" contains either the word "Assigned"…