-
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…
-
how do I automate workflow based on a check box?
Hi. I have a sheet the checks and unchecks a box based on inventory levels; when inventory drops below a certain number the box is checked and when it rises above that certain number the box is unchecked. Next, I created an automated workflow that is supposed to copy a row to another sheet when a box is checked but for…
-
Why does my Index/Collect Formula stop working after 8 rows?
Hello, my formula stops working after it gets through 8 rows. I have a picture below where I'm just testing out 30 rows but I need this to work for about 4000 rows, however I can't figure out why it gives me an error after awhile. This is my formula. =INDEX(COLLECT($ItemCategory$1:$ItemCategory$30, $[Date Order]$1:$[Date…
-
I am trying to have a column to show me the next date of a given month and day.
For example, I have a column that has contract renewal dates. These would be Jan 1 Aug 1 September 1 December 1 Etc … I would like the column next to it to figure out the next date based on todays date. If today is August 28, These values would be: Jan 1, 2025 Aug 1, 2025 Sept 1, 2024 December 1, 2024 Is this possible?…
