-
Help with formula to return month + year from "Date Created" field.
I am trying to create a column formula to return the "Month Year" from a "Date Created" field, with the month fully spelled out. This is what I have so far, but for some reason it is returning the blank value even though the date created field has a value of "03/01/24 11:13 AM." Additionally, I need help figuring out…
-
Using cross sheet reference to pull data from one column in Sheet 1 into multiple rows in Sheet 2
I have two sheets. Sheet 1 is essentially a directory. It lists all of the individual contacts that are involved in a project. Some columns in the sheet are are "Name" (Contact List), "Title" (Text), "Department" (Text), and "Completed Assignments" (Text). Sheet 2 is where monthly assignments are recorded. The columns are…
-
Help on formula: count if with multiple criteria
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender", Stage:Stage, "evaluation",…
-
Calculate Entries by Month and Year
Hi everyone, I am currently capturing the month and year an item is closed. Colum A shows the Month, column B shows the Year ([Jan] [2024]). Can someone tell me the formula that I can use to count the items that are closed in a particular month? To calculate the entries closed in Jan I've tried using: =COUNTIFS([Request…
-
Populating a Text/Number field with an email address from a Contact List
Hi SmartSheet community! I'm trying to write a formula that will allow a user to select an entry on a Contact List column, and have that person's email address auto-fill a Text/Number field (which is used in an auto-generated notification message). What's the best way to do this? I've set up a secondary Contact List sheet…
-
COUNTIF not blank
I simply want to count all of the cells in a column that aren't blank =COUNTIF(COLUMNA:COLUMNA), "isnotblank") This doesn't work Any ideas?
-
Is it possible to flag duplicates when the data starts with a 0 (zero)?
Hi! I have a sheet that tracks hundreds of cell phones, so it's really important to ensure existing records are updated rather than added as new rows. I can flag columns like Asset Tag and Phone Number with this formula =IF(COUNTIF([Asset Tag]:[Asset Tag],[Asset Tag]@row)>1,1,0) . The problem is that this doesn't work for…
-
Current Month Data Pull
Hello, I created a scorecard system to manage performance for our vendor base. I am attempting to pull a report of average rating within the current month. I was able to put a formula together, which is honestly intense, and it worked for the month of November, but as soon as December 1st hit, it wouldn't work. I believe…
-
Formula to find the first occurrence and return the date
I'm trying to create a formula that looks at the client's name and returns the event date but if the client's name is a duplicate the return only the event date of the first occurrence, but I am getting an unparseable error. Help? =IF(COUNTIF([Client Name]1:[Client Name]@row, [Client Name]@row) = 1, [Event Date]@row,…
-
Parent status based on children
This gets asked all the time and I've looked through posts but I can't get the formulas to work for my project. I have a project with hierarchy 1,2 and 3. I need the parents' status to update based on the children. My status options are: Not Started, In Progress, Complete and Blocked. If one child is in progress or…