-
COUNTIF/IF Formula Help
Hello, I'm trying to combine a COUNT IF and IF statement to another sheet. Here is my formula: =COUNTIF(IF(AND([14 Apr 2024]1 >= {Project Intake Start Week}, [14 Apr 2024]1 <= {Project Intake End Week}), 1), >1) Essentially, I have an IF statement that says if a number (referenced on the sheet) is between two numbers on a…
-
If then Formula help
Hello! Looking for help with my formula that would enter the text "complete" if the checkbox column was checked and if the checkbox column was not checked it would subtract the due date from today's date to get days remaining. Here is my attempt at a formula - thank you for the help! =if([Data Received]@row, 1 =…
-
Help with a Formula?
Hi, I am working on row of dates and I am trying to get the next due date (from today) in another column. I have tried a couple of formulas but get #UNPARSEABLE. What should the formula be? I am looking for the formula for the cell in yellow.
-
Formula Help - Works in Progress Based on Start and End Dates
Hello, I am working on a resourcing sheet to look at works in progress by the week. I have a sheet that has a column for each week of the year. I am working on a formula to reference another sheet which has a list of projects with the Project Manager and start and end dates. For each week of the project (the start week,…
-
IF Statement based on multi-value drop-down
Hello All, I have an IF statement that needs to execute a formula if True, and present a statement if False, typical I know. But I need this to work based on the multiple values that can be selected in an adjacent cell. I've tried IF CONTAINS or IF HAS and have not had success. Let me know if anyone has encountered this…
-
I need to calculate the estimated end date of a project based on working days
To calculate the end date of my project, I need a formula that would take today's date and add the number of working days left to it. I keep getting an Invalid data type error. The Today's Date column and my Estimated project finish date column are both set as Date column types. My Days Left column has it's own formula…
-
Calculating a review date based on both the hire date and last date of review
So I've burned up about 6 weekends working on this, and have asked a few peripheral questions on it, but never just asked the whole thing. I met with a Smartsheet pro and he suggested I bring this to the community. I would really appreciate some help on this. I need a formula that will calculate the next review date…
-
Month and Year output as text
Hi everyone, I need to generate a month and year from a date (text month, not number) For example, 1/1/24 becomes 'January 2024'. Specifically, I need the day removed. Is there a more efficient way than this formula: =IF(MONTH([Date Column]@row) = 1, "January", IF(MONTH([Date Column]@row) = 2, "February", IF(MONTH([Date…
-
Incorrect Argument set with IF and VLOOKUP
Here is my formula - =IF(Activity@row = "Field", VLOOKUP(Employee@row, {Employee Payroll Info Range 2}, 9, false), IF(Activity@row = "Bakery", VLOOKUP(Employee@row, {Employee Payroll Info Range 2}, 8, false))) I am trying to determine which hourly rate to use based on activity performed.
-
Count IFS & Contains
I'm trying to count the number of times a specific string of text is referenced in a column on another sheet. I've tried multiple ways, but it doesn't seem to come out right - =COUNTIFS({KPHI: SHP Master Patient Tracker_ProcType}, "TAVR", {KPHI: SHP Master Patient Tracker_Comp@Proc}, CONTAINS("Arrhythmia, 1st Degree AV…
