-
Needing Two Timestamps in One Smartsheet
Hello, Can someone please assist with having two timestamps? I need to have our "Timestamp" in the first column when the customer submits a quote request, and another timestamp in "Arista Timestamp" (with date and time) of when "Quote Request Sent To WWT?" changes to "Yes". Right now my workaround is to have it record a…
-
Matching a Name to another sheet and is checking a row if it is a date
=IF(AND(MATCH([Team Member]@row, {Team Member}, 0), ISDATE({L1 Mixer})), 1, "") This is what I try and it returns incorrect argument set on the first row, but invalid data type on the remainder. It is a column formula.
-
If any of the cells being searched are not blank return a 1
=IFERROR(IF(AND(MATCH([Team Member]@row, {Team Member}, 0) > 0, COUNTIFS({Team Member}, [Team Member]@row, {L1 Mixer}, {L2 Mixer}, {L4 Mixer}, {L5 Mixer}, {L6 Mixer}, {L7 Mixer} <> "") > 0), "1", "0"), "Error") It is searching for all of them returning not blank. I am wanting if any of them are returning not blank.
-
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:…
-
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…
-
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…
-
COUNTIFS Column A is blank and Column B does not contain 1
Hi All, I am struggling to make the COUNTIFS formula work in a Sheet Summary Field where Column A is blank and Column B does not contain 1. NOTE: Column B is a formula column with the following - =COUNT(ANCESTORS([Risk Number]@row)). =COUNTIFS([Column A]:[Column A], "", [Column B]:[Column B], NOT(CONTAINS("1", @cell)))…
-
Formula regarding parent / child rows
Hello, I'm trying to create a formula to automatically populate a column based on if the row's primary column cell is a "parent" or "child." The column I want to automate is titled "Level." If the primary column cell at that row is a "parent", I want the "Level" column cell at that row to automatically populate "1." If…
-
Tracking Contact Approvals in Hierarchy Level using Helper Column
Hello Smartsheet Community, I'm creating a Smartsheet Automation to send out approvals (starting with level 1). I'm making this helper column (L1 - Status of Approvals) to determine if all the listed contacts have given approval in the contact approval columns before moving onto level 2. As you can see in the screenshot…