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…
I need help creating a formula that will link the "Key Date" from the Project Intake Sheet to the launched project within the Sheet Summary field. Essentially, it needs to be able to link back to the …
I have dates in the Feature Added column, 02/15/2022, 02/05/2022 etc. I use a formula in my Feature Month column to convert those dates to mmdddd =IFERROR(RIGHT("00" + MONTH([Feature Added]@row), 2) +…
Hi there, I need assistance on this IF formula. Formula I have: =IF([Company represented by an attorney]@row = "Yes", "Yes" +[Name of Company]@row + " Has signed contract with others. The purpose of t…
Hello, I think it's a sum if formula I need.... If the source column says "external review" and another column called Significance says "Major" I want to return a date of +60 days to the date within c…
Hello, I have a situation where we teach virtual classes that are each approximately 2- 4 hours in length, start and end at various times each day, and each requires a unique conference phone line ded…