-
Pull data from a sheet to another with multiple columns
Hi, I am new to Smartsheet, and trying to see if anyone can help me with the formula. I am trying to pull a value from row spilt in multiple columns to a different sheet. Product name is the Primary column in both sheets and I need information pulled from various columns Customer LOT. Each row has one value only in one of…
-
formula with edit reference
I am unable to edit the reference in this formula that I have copied from a previous line. it is a continuation on the sheet from 2025 to 2026. this is the formula, I would like to change the CC AD Staffing to the new page for 2026. But when I try t change the 2026 reference (sheet) it changes the 2025 reference to an…
-
Can't use Vlookup or Index Matching
Hi all, I have a sheet which is organising workflows for different departments. Departments are separated into different sheets since they have different tasks and metrics to monitor and some activities are sequential therefore moving once finished with one department by automation. How can I get row info from 1 sheet to…
-
Formula help to calculate sum of items across smartsheets
Hi Smartsheets community, I've recently created a Smartsheet with all the different types of meetings and then I have separate columns for the count of meetings attended, missed and chaired. In a separate worksheet, I wanted to create a summary (not using summary report) but it's only counting the number of rows created…
-
Countifs using multiple columns + if date is in the last 7 days
Hi all, I have two different formulas that I want to combine. They work separately, but not combined. Formula one =COUNTIFS([Roof AHU 1&2 Base Build Supply Fan]:[Roof Lights], "Yellow") Formula two =COUNTIF([Date of Plant Check]:[Date of Plant Check], >TODAY(-7)) I want my formula to pick up where the symbol is yellow but…
-
Logic: Looking for the Duplicate Function and Conditional Logic
Good Evening, Essentially, I want to search for the duplicate in both lists and then: Option #1: delete the duplicate from the Comms-LIST Deliverable Option #2: if deletion is not possible then white out the text in the Comm-List Deliverable Thanks as always for your brilliant mind, NCNW, Inc.
-
Cyclical or Yearly Events
Every year, employees need to update their benefits, complete their performance reviews, etc. How do I add a cyclical event to a project plan? Visuals are greatly appreciated! Thanks! Millie
-
Can anybody explain this seemingly impossible formula result
We have this formula in the [Task Status] column of every one of our 82 production sheets (as a column formula). See the attached .txt file for a pretty printed version of the formula. =IF([DTM?]@row, IF( OR( ISBLANK([Start Date]@row), ISBLANK([End Date]@row), NOT(ISDATE([Start Date]@row)), NOT(ISDATE([End Date]@row)),…
-
Freeze Rows
Allow the freezing of rows.
-
Nested if not working
Hello, I have some simple nested if as following: =IF(ISBBLANK([Ticket Date]8), [Ticket Date] + 38,IF([Detection Date]8 < DATE(2024, 4, 30), DATE(2024, 4, 30) + 38, [Detection Date]8 + 38)) for some reason, the first [Detection Date]8 always get unparseable error, but 2nd [Detection Date]8 has NO issue, I copied the 2nd…