-
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…
-
HELP!
I am trying to match asset number hours that automatically come in via form and pull them into a separate data dump of current inventory. I only want the highest value since the number of hours are reported daily.
-
I am trying to get a unit count between a date range.
I am trying to get a unit count between a date range. I have two difference columns from one sheet and two difference columns on my main sheet I am referencing. I keep getting unparseable. Is there a way to to get the number I want with using the countifs formula? Or should I be using a different formula? This is the…
-
COUNTIFS formula for any future date?
Hi all, I am trying to create a COUNTIFS formula that counts if the due date column on another sheet is today or any future date. I tried =COUNTIFS({due date column's range}, >=TODAY()), but it is not working. Any advice would be appreciated! Thank you.
-
Converting MM/YY into MM/DD/YY for date column
I had searched on here a couple times and tried some of what I found, couldn't get it to work. I have the date imported in MM/YY format as a text column. I'd like to have a date column next to it, with MM/DD/YY, with the DD being the last day of the calendar month. Am I aiming too high?