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…
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 Sub…
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 …
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: Żako…
Hi Community, Do you use the TODAY Function in any of your formulas? If so, there are a few different ways you can make sure this function is updated daily to reflect the current date without needing …
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 +…
Hello! I am trying to create a formula that automatically check the box if the "Year upgrade or addition" cell contains the year 2012 or later. In my screenshot, you can see this cell contains the yea…
[Allocated Team] is the team that the project has said they need and at what allocations they need them, JOIN(COLLECTed from the children of this parent row =JOIN(COLLECT(DESCENDANTS([Employee Name]@r…
I am working on a calculation model for my company and essentially I am looking for Smartsheet to give me the following information. I currently have the formula for the first part figured out, I need…
Hi, I have a sheet that captures hours from a vendor. Hours and rework counts (number of times an issue goes into rework) are entered. I need to sum hours and rework counts for the previous month. I h…
