-
IF AND based on an input + or -
I can get this to work and in my head it should :) I want an "In Spec" IF… the Stage 1 Temp Verification is less than or equal to S1 Temp minus 5 AND Stage 1 Temp Verification is great than or equal to S1 Temp plus 5. =If([Stage 1 Temp Verification]@row) <=([S1: Temp]@row + 5), ([Stage 1 Temp Verification]@row) >= ([S1:…
-
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…
-
ISCRITICAL is FALSE for a PARENT task with CHILD tasks that are on the critical path
I have a project plan where the child tasks are on the critical path with ISCRITICAL = TRUE, but for the parent task, ISCRITICAL = FALSE. Is this expected behavior? Context: It's a waterfall project. Only the child tasks have predecessors and successors so that the dates and duration for the parent task adjust when the…
-
How to average the time between various dates if conditions are met
I'm building a spreadsheet with monthly metrics and having issues creating a formula. There will be a separate smartsheet with individual events (1 row per event). Each event has ~3 review cycles. Each review cycle includes the date the draft was provided & the date the draft returned. Formula I'm trying to build: If the…
-
Form to populate answers against unique ID
Hi Team, I need to collate data from employees for an upcoming project. Has the form got functionality to recognise unique identification between answers and link it to relevant row yet? My ideal sheet would have all employee names, their unique staff ID and relevant fields I will ask them to give me answers for via the…
-
Calculation from Sheet with shuttled Data to combined data
I have a sheet that is refreshed every morning to add and update existing data from an in-house data warehouse. I am trying to create a sheet that pulls from the original sheet and can produce a graph in dashboard that tells me how long something has been in a current state, with many things being in that state for various…
-
Formula to display one date in a range with 3 criteria
Hello everyone, Can you please help me with a formula? I have three columns: 'Start date' , 'Dose', 'Site'. I would like to consider multiple criteria: 1) the start date is in the future 2) the value in the 'Dose' column is 'drug' and 3) the Site is '01'. Based on these criteria there should be a list of dates, but I would…
-
Percentages lost when indenting linked cells aka best way for roll up smartsheet
Hello I am trying to connect about 50 project plan sheets on one sheet. The requested configuration is a traffic indicator for a customer then the ability to drill down to see each customer project and status then a drill down for high-level milestones. FYI I have just read about the limitations so I understand eventually…
-
How do I customize a request ID based on specific form selections?
iaI know how to create a request ID on the column grid but I wonder if I am able to customize based off of specific selections on form submissions. For example, Jane Doe selected content management (CM) in her form submission so the request ID would reflect that (Request ID: CM_0001), where John Smith selected quality…
-
How can I make COUNTIF into a column formula?
I have been using a COUNTIF formula that I am unable to convert to a column formula. Is there a way that I can alter it so it can be a column formula. This is what I have: And this is the message that pops up when I try to convert it to a column formula: I just don't want to continue to drag the formula down with each…