-
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β¦
-
Count the average number of days based on criteria from another column
Column A - "CO Type" and only has two options - Fixed or T&M Column B - "Average Days for Approval" and is calculated from two other columns - " Date Submitted" and " Date Approved" I need a formula the will average the number of days for approval from Column B and for all the Fixed and T&M rows in Column A. Help!
-
Moving non-numeric characters through INDEX
So, I'm trying to build an intake form that will let users fill out their information and then automatically grab that data and put it through a "Calculator", where it will then get pushed to a 3rd sheet for printing. The issue i'm running into, is that while I can use =INDEX[Example Item A]1:[Example ItemA]1 to grab theβ¦