-
Cross Reference Two Sheets
Hi I am very green smart sheet user and I need help typing up a formula. I want to reference emails in a column from one sheet called "Active_Master Contact Sheet" in the column "Email" and enter that email into my "World Series Master Crew List" in the column "Personal Email" I am getting hung up on how to make that…
-
How to count several non-blank rows based on specific criteria across two sheets
Hi Community! I have two different grid sheets within smarthseet with the following information: In sheet 1 I have several products that need a certain number of photography shots and being delivered in different channels. Each row has a due date. In sheet 2 I want to find a formula that would give me the numbers in blue.…
-
How to identify if a checkbox has ever been checked
Good morning, friends of Smartsheet, I need some help working through a process. I have a worksheet that has a checkbox column called 'escalate'. When we check that box, the row shows up on a report that our Compliance group can see, so they know their assistance is needed in some sort of communication efforts. Once the…
-
Unique Id in one sheet and Duplicates Id in another sheet
Hi Good people I have two sheets - FTTH Program sheet and the PMO_DataDump sheet On the FTTH Program sheet i have the unique id - PN number and on the PMO_DataDump also have the unique id with duplicates (PN Number), I'm trying to Calculate the sum from the column called HP from PMO_DataDump sheet for every unique Id in…
-
Why didn't my original CountIF formula work?
I am trying to count the number of projects that began since Jan 1, 2024. I typed in the formula =COUNTIF([Start Date]:[Start Date], ">= Jan 1, 2024"). Basically I wanted to count the number of projects with a start date that were equal to Jan 1, 2024 or greater. However that formula gave the blatantly incorrect answer.…
-
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
-
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!
-
Formula Help
Hello, I have a formula to determine the days between two cells: =IF(OR([Status]@row = "CLOSED", ISDATE([Closure Date]@row) = 1), [Closure Date]@row - [Date Initiated]@row, TODAY() - [Date Initiated]@row) However, I need to add in to return "N/A" to the days open if the value within Date Initiated is N/A. I have a similar…
-
Counting Active Projects
Hey! I am wanting to count the number of projects in each department (e.g., Health Action) that are marked as active. I am currently using this formula where I manually enter how many inactive project to subtract from the total but I would like to have this imbedded in a formula so it updates automatically. Thank you!
-
Join row data formula
I have two sheets for a traning evaluation form. They both have a common column, TrainingID. Based on that column I want to bring in data from one sheet to another. Example: For all rows that have BLS05 as a Training ID, I want the data columns from Facilitator Information to merge with the Evaluation sheet Facilitator…
