-
IF/AND Formula not working for Date falling within a specific Month
Hi, I am struggling to get an IF/AND formula to work correctly, and hope someone can help me. The formula is in a text/number column labeled "Oct". I need the formula to look at the date column labeled "Proposed Start Date" and the date column labeled "Proposed End Date". The proposed start date and proposed end date…
-
How to prevent Countifs column formula from updating previous cells.
I have created a log book request form that needs to generate a unique ID (YYYY-##-###) based on 3 criteria: Year submitted (4 digit year), Site Code (preassigned 2 digit site code), and Log Book Type request count. The formula I'm using performs as needed, except it changes previous Log book numbers that have rows with…
-
Counting # rows submitted in a particular month and year
Hello, my current formula only counts what month a row was submitted but not the year. How can I get the formula to also count the row if it happened in January of the current year? =COUNTIF({Date Submitted}, IFERROR(MONTH(@cell), 0) = 1)
-
Using if function and vlookup
I would like to populate sheet the first sheet shown below which is entitled "Process Step Capture Tool" with data from the second sheet below entitled"Test Sheet" and I think I need to use the if and vlookup functions. What I am trying to do in the top sheet is say if the Process # is Process 1 then add the corresponding…
-
SUMIFS Help
Hi all, Having an issue with a formula; I want to sum column 3 based on fulfilling criteria from 2 other columns eg If Column A says "Product" and column B says "2024 May" then sum column Column C It may seem simple, but having issues... Thanks
-
Remove Accented characters and replace with non-accented characters
Hello, I have an intake of name data in three columns: First Name, Middle Name and Last Name. I have then got a formula to join them up in a fourth columns: E.g., Selma Anna Żakowicz will become: Żakowicz/Selma Anna Joined Up Formula: =[Last Name]@row + "/" + [First Name]@row + " " + [Middle Name]@row This joined up column…
-
Automation / Form Assistance
So we have a Project Register that logs all of our Projects, Project Manager, Name of Project etc. On this register I have automation set up so that every 3 months it will send and email, containing a survey (form) to assess customers satisfaction. For said Survey (Form) I also have an intake sheet. However I have a couple…
-
INDEX MATCH or something else?
Hello everyone, I need your help setting up this formula in Smartsheet, since we don't have the formula LOOKUP, as I have in excel. I have this table, where every time I add the [Site] number: 301, 302 or 303, it will look for the last [Actual Visit End Date] for the specific site number, and bring the last day of the…
-
Need help
Hi, I have another question. I am trying to create a formula that will take the value of a contract and apply a percentage of completion to any contract that has been won. So, I need to have a formula that looks at the sales stage and chooses those we have "Closed Won" and multiplies the percentage of completion by the…
-
IF/THEN/Else with Dates
Hi All! I'm needing to create a column date formula for if appointment type = a or b, then Report Due Date = Appt Date + 60; and if Appointment Type = anything else, then report due date = appt date + 30. Based on answers to other similar questions, here is what I have so far: =IF(APPOINTMENT_TYPE@ROW="SIBTF_-_INITIAL",…