-
Updating Date column with Date Column in another sheet with a condition
I have two sheets with a lot of columns. Both sheets contain a Docket No. and a Hearing Date Column. I am trying to have the Sheet 2 look at the Docket No. in Sheet 1 and if the Docket No. is the same to update the Hearing Date Column in Sheet 2 with what is entered in Sheet 1 and always stay updating should there be a…
-
Moving children rows under a different parent row
Is there a way to set up a formula that will move project status "completed" from under one parent row to another parent row named "Completed project" once the project status has been selected as completed?
-
Help with Parent / Child row auto numbering
Hello! I have a sheet that is being used to track decisions. We have a parent row (blue) and then child rows (white) for each group that needs to make a decision. We want the parent row Decision IDs to be sequential numbers "EHR###". The problem I'm running into is that each child row gets an AutoNum as well so as new…
-
How to output a list based off of a cell
Hi, I have two columns on my source sheet with employee's names, whether they are a project lead or project team member. The project lead column will always have one employee, whilst the project team member will likely have many. I want an output where something will be filtered based off of a cell. For example, on the new…
-
Using IF and IFERROR, but it's only returning an empty string
My formula first checks if Decision or PM Status is any of the following values. If true, it returns an empty string. If false, it checks if the Sprint Delivery date is earlier than today. If true, it returns the Request ID. If false or an invalid date, it returns an empty string. Here is the formula: =IF(OR(Decision@row =…
-
Formula for "Due date = 3 business days before Deploy date?"
Hi, I would like to build a formula with the following logic: "Due Date = 3 BUSINESS DAYS prior to Deploy Date." Building a "3 DAYS prior formula is simple enough, but I'm wondering if anyone has solved for logic that can only offer a day that's Monday thru Friday. I appreciate any advice! -Adam
-
If Blank formula
Hi, my problem is probably very simple to most of you and I thought I had it, but it keeps saying "unparsable". I have a date column which I want to break down to a month - for example I want 22/07/2024 to be just 07 - this is so that I can then populate another corresponding 07 column with some £ data. I have worked out…
-
Formula for If Then statement Error Incorrect Argument Set
Desired Objective: Working on a column formula for Baseline Pass/Fail # Records with Errors If Baseline # of records audited = blank then blank If Baseline Audit Fail Rate Formula is greater then 20 then "Fail" Else "Pass"
-
Help with Nested Formula
Hello, I've got the below formula to sorta work, but the problem is that it is not giving me a return if my value falls outside of the last formula (>500). I even tried the second formula, but it put everything to 5 no matter what. See screenshot below (1st formula). Thanks in advance. =IF(Lipemia@row < 40, "0",…
-
How do I show a holiday in a date range?
I know how to add holidays into my project settings so that Smartsheet automatically adds another calendar day to the timeline. Now I want to show the name of the holiday that falls within a date range on my project plan. That is, if I have a task that starts December 20 and ends December 27, is there a way to indicate…
