-
Find no duplicate on another sheet
I'm stumped. I have a column called "code" on two sheets. I'm trying to flag the rows on sheet 1 if the code isn't found on sheet two. I feel like it should be simple but I keep getting error messages.
-
Help with formula for schedule health
Hello, looking for some help with calculating schedule health. I have added a symbols column (Green, yellow, red, gray circles) called schedule health to schedule. I have started creating a formula to calculate the schedule health for each row. This is what I have based the formula on: On Track = Green. Occurs when ‘%…
-
Calculating Variance between Due Date & Date Delivered
I am new to smartsheet and I am looking for some guidance: I want to calculate the delivery variance between the Due Date & Date Delivered. Both the columns are Column Types is Date (I also tried with Text/Number, but doesn't help.) The issue I have is that for any date that it is delivered on or after the due date, it is…
-
Calculating average time spent in each phase
I am looking to create a sheet that moves through our 5 stages of work and how much time is spent in each phase. What is the best way to go about this?
-
Cant add 3 months onto a date in the next year when the date is between October and December.
I am trying to add a column formula whereby a date is added in one column and in another column 3 months is added to the first sou,n's date. This works fine where the month is between January and September. However if 1 October 2022 is added the date should be 1 January 2023. It lists it as 1 October 2022. (the same). IF I…
-
How can I create a function that separates a string of words separated by commas into rows?
=JOIN(COLLECT([column1]:[column1], [column1]:[column1], ISTEXT(@cell), [column2]:[column2], =""), ", "). Right now, I have this function in my sheet summary to concatenate all strings that have text in column1 and has no text in column2. The output it gives me looks something like "task1, task2, task3, task4, task5, task6,…
-
IF / AND / #INCORRECT ARGUMENT SET - Formula Help
I'm trying to assign a "Status" column of Not Started, In Progress, Overdue, Complete, or Not Applicable (if a box in another column is checked), and am getting an error of #INCORRECT ARGUMENT SET. Appreciate any help. I've spent way too much time on this. :-) =IF([% Complete]@row = 1, "Complete", IF([Task Not…
-
Auto Populate Children Dates based on the parent first day of the month
Good evening - I am looking to create an auto date that maxes based on the month (i.e. 28 days in February or 30 days in September) based on the parent row. I originally had it by calendar year and organized by the Month as the parent, and that parent row has several values that are linked to other sheets, however, I was…
-
Task Health Calculation using duration and % complete
I am working on a formula to calculate task health with R/Y/G harvey balls based on the duration of a task and the % complete. I have found several community discussions around this but the ones I have found , I have not been able to successfully tweak to work in my sheet. In my sheet, I have Start Date, End Date,…
-
Cross Reference
Can you have some rows reference one column in a sheet and other rows reference a different column in the same sheet? It seems like I am getting a message that when I reference a column all 1000+ cells are changed to that reference, but I have 26 rows I want to point to a different column. Do I have to relocate them to…
