-
Count of Children Code not working on top row of schedule
I have code that are in all parent rows of a project schedule. This code works on all parent rows but the very top which is the full status of the project. Can you help me figure out why it is working on all other parent rows but the very top of the schedule. All other rows in the schedule are children to this row.…
-
Add additional criteria
Hello... here is my current formula below. How can I also add a condition to only average if number in range 8 is >0? =AVERAGEIF({Technical Certification and Competency Tra Range 4}, [Contact List]@row, {Technical Certification and Competency Tra Range 8}) Thanks for any help.
-
Separating a series of number separated by spaces into multiple cells
Hello! I have a Smartsheet grid that is updated via a form input. One of the columns, "Label ID", is dedicated to cell that contain a series of numbers that are separated by a space (10067 4866 48676 3857). These numbers can vary in length. Is there a formula that can allow me to separate these numbers into separate cells?…
-
Cross sheet IF formula
I am getting Unparseable error for this formula: =IF({Reference sheet 1} >= {Reference sheet 2} "Yes", "No"). I am trying to determine if number in sheet 1 is greater than sheet 2 in a particular column, then input yes in the 3rd sheet and vice versa. Is it possible to use IF formula across sheets? If so, what am I…
-
Yellow Code Not Working in Formula
I have the underlying code in a sheet to look at specific items in a row. The Red and Green Code is working as expected by my yellow code is not. I am assuming it has to do with the way I have sestup the today function I have tried both =TODAY(2) and >=TODAY(2) niether seems to work. IF(AND([Due Date]@row = TODAY(2),…
-
Impossible to countifs on an empty column
Hello, i have this formula that works fine : =IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso pivot Range 1}, CONTAINS([Region / IE_ID]@row, @cell), {Stage}, "Stage0")) However when I add this last condition : =IF(ISBLANK([Name of LE]@row), "", COUNTIFS({Fn}, "HR", {LEC - Action list conso…
-
Total time-off days by year
I am having trouble creating a formula on my Staff Total Days Off sheet that pulls information from my Time-off Request Log sheet but for a specific year. Sheet 1: Time-off request sheet tracks each employee's approved time-off dates and days with an additional column for YEAR of request. Sheet 2: The Total Days Off sheet…
-
Find Duplicate Values in one Column
I looked and cannot find a solution, I have employees who are signing up for a course and some are doing multiples for various reasons (not all legitimate) and I would like to find out how to see who has multiple entries so I can delete the ones that should not be duplicated like with excel where I can highlight but…
-
Adding Looking inbetween Two Dates
Hello! I have this code below and am trying to add if: column x and y are between 1/1/24 and 12/31/24. =COUNTIFS({GDP Project Tracker Range 5}, "<0.05", {GDP Project Tracker Range 2}, "HSB", {GDP Project Tracker Range 3}, OR(@cell = "Active", @cell = "Launched", @cell = "Planned")) Please let me know and any help would be…
-
Is there a possibility of doing this?
I have a project plan within control center. Each time I create a project, the same template will be used and populated accordingly. Within the project plan template, we created a formula that when someone updates the status of one of the steps from 'Not started' to 'In Progress' the step will show in the 'Current Phase'…