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…
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 d…
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 looki…
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 whi…
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 i…
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…
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 …
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 th…
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,…
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 Mas…
