-
Formatting in Formula Cells
I have two date cells that I have formatted as long dates (May 30, 2018) titled Contract_Begin and Contract_End. I want the formula cell to read contract begin date through contract end date (for ex: May 30, 2024 through August 10, 2024). However, the cell formats to 5/30/24 through 8/10/24. I posted the formula I am using…
-
Automation help or formula for connecting rows
AW Placement request form below takes in all of the school placement requests via a form. Once the column AW REQUEST STATUS is 'approved by leader' it is automatically moved to Students/Instructors - AWI The ANCHOR ID transfers over from AW placement request sheet to students\instructors - AWI - when approved by leader…
-
Fórmulas a la hora de crear automatizaciones y flujos de datos
Buenas tardes, Tengo un par de consultas acerca de las fórmulas a la hora de crear automatizaciones y flujos de datos.Por un lado, cuando se crea una automatización no he visto forma de que añada una fórmula en una celda, ya que si la creo como "Cambiar valor de celda" no lo aplica como fórmula, le añade un apóstrofe al…
-
SUM Rows in Column A that meet multiple criteria including distinct values in Column B
I am trying to use a formula to: Referencing other sheet(s)… Sum story points by PE (Person) if: The Parent PCR (Identifier) is Unique The PCR Status is one of 5 options The PE assigned is an exact match (ie "Derrick Franklin") Here are a few that I feel are close, but not giving me the exact number's I'm looking for: This…
-
Collect Multiple Row Data into a Single Cell Reference
Hi Smartsheet Community, I am attempting to create a meeting planning set of sheets, and I am struggling with the following. SITUATION: Provide a formula for referencing a stakeholder register sheet for the name of a meeting attendee, and display their PTO in the cell. Please note that there will be multiple attendees for…
-
Cross Sheet Formula Limit Error
I'm currently getting an error related to the cross-sheet formula limit. I'm not sure why I'm getting the error. So far I have referenced 6 columns in other sheets with SUMIFS formula. I received the error when I added the 2019 formula below. There are ~17,000 records on the referenced sheet, would that be causing the…
-
Not able to count total of different percentage fields?
I'm trying to get a breakdown of how many of each percentage group we received from this quiz and I've tried totaling from a percentage column as well as when the column is set as a decimal and I just keep getting 0 as a total, only the 100% has worked. Not sure if I'm just overthinking it or what, but here are some…
-
Please Help
I am trying to use this formula- =IF(CONTACTVALUE({Hardware}) = "Andrew Mattos", [Points Bucket]@row - 10, 0)- Basically I want it to search my TR Project sheet for the Hardware column and if it see's Andrew Mattos contact to subtract 10 points from my point bucket column in my data sheet. It keeps coming back Unparseable.
-
Cross-sheet & condition-based formula
Hi all! I need a formula that imports a reference number (auto-generated) from a column in sheet A (source) into a column in a separate Sheet B (destination), but only when a separate drop-down column in Sheet A changes to a specific value. Using a filtered report in lieu of Sheet B is not an option (at least not…