-
Basic Formula
I have a list of customers in 1 sheet and I want to have a dropdown list in a column in another sheet link to it so I can have a dropdown of those customers. I also want to be able to add a new customer to this list if needed.
-
RYG Health Status based on "Activity Status" and Sprint End Date
I'm a fairly new Smartsheet User but starting to catch on fast. Please forgive the noobie question. I'm trying to set a Red, Yellow, Green - Health Status to an activity but I would like it to be based on the following parameters: 1) Red IF Today(-3)days from the [Sprint End Date] AND [SPRINT ACTIVITY STATUS] = "In…
-
Star/Check only rows that are unique/not blank
I'm trying to count the number of unique attendees for a training session on a registration form by pulling data from both the registration form AND the roster for the specific session's date. My current formula is =if(countifs({08/08 DC Registrant},[Email Address]@row,{08/08 DC Attended},@cell=1)>0,1) and it works,…
-
Max formula with created date column
I'm having a very weird issue. I'm trying to use the Max function to deliver the most recent created date. I have a column type with created date which I have named "created". I've input the following formula =Max(Date:Date) and I keep getting an "invalid column value" error. What am I doing wrong? I would eventually like…
-
HELP! Somehow my sheet copied all the formulas and overwrote everything!
Without touching anything (I swear!) I logged into Smartsheet and my very complicated formula driven sheet that was built with each row using it's own formula now has the same formula copied for each row. The activity log shows "conditional formatting applied (120)" that is the culprit - the formulas changed not just…
-
Date formula Question
Have a summary sheet for my tracking sheet and am looking for a formula that tells me how many of a source/type (01_CNJ) have a date in a specific column. Current formula (#unparsible): =COUNTIFS({REFSheet_Source}, "01_CNJ", {REFSheet_Date}, IFERROR(2023(@cell), 0) = 2023)
-
Formulas Done vs Complete
With the formulas I currently have they work just fine. The small detail is that when they are not completed it says "2 of 3 Done" but when completed it says "6 of 6 Completed" (See screenshot). I know its minor but I was hoping to for a way to keep it consistent either all Done or all Complete. These are the formulas I…
-
Error Message- Boolean expected
Good afternoon everyone, I am using a checkbox column to count if an inspection has been completed for each quarter. I understand that anything greater than 1 in this type of column will result in "#BOOLEAN EXPECTED." What I'm wondering is...is there a way to change the error message into a "Duplicate Inspection"... or…
-
Formula - Row Summary
I have 2 different sheets going into one report so I can track benefits/staff adjustment changes through the year. When it comes to renewal time, I would like to be able to pull down the most current information into one row. Is that possible?
-
How do I keep track of the number of statuses that change per day?
I have a sheet where every column is assigned a status. These are 1, 2, and 3. I want to keep track of how many rows change status. In other words I want to keep track of the change in status counts automatically. The end goal is to add this to a dashboard. i.e. I want to know how many rows go from status 1 to 2, 2 to 3,…
