-
Unparseable Error
Hi, I would like to add a health status formula but i am receiving an error. =IF(Status@row = "Not started", "Blue", IF(Status@row="In Progress", "Yellow", IF(AND(TODAY() > [end date]@row, Status@row="In Progress"), "Red", IF(Status@row="Complete", "Green")))) Any help would be greatly appreciated.
-
"CountIF" issues
Hi everyone. I am trying to get Smartsheet to run a basic COUNTIF function, and it's finding #NO MATCH. The formula is: =COUNTIF([PE Manager]:[PE Manager], CONTAINS("Anna Richey", @cell)), where I am trying to count all instances of the name "Anna Richey" showing up in the [PE Manager] column. Any ideas what I'm doing…
-
Combine data from multiple columns, unless data is the same
Hello Smartsheet Community! We have (2) sets of columns of data that pull in data from (2) other sheets for Ship Dates, Tracking, Order Numbers, etc. Sometimes both sets of columns will be populated sometimes just one column will be populated. We are currently using the JOIN function to combine the data from a set of (2)…
-
How to link cells from a form to automatically update in a separate sheet??
I am trying to link a couple of cells from a recruitment request form into a separate candidate tracker sheet. I am using the form template to keep track of recruitment requests and a task shee to keep track of candidate procedures. I was envisioning the candidate tracking sheet automatically updating when a recruitment…
-
How to prepopulate a form using the row as a reference?
Hello, I apologize for the simple question. I am a beginner with Smartsheet but I have not found the question answered in the help sheets. I would like to prepopulate a form answer using the row as reference. I can get the form to prepopulate but I have to enter the address manually in the formula each time. I have…
-
CountIfs Date Range
Hello! I'm trying to pull the line count on another sheet if the line's completion date is within the start and end date of another sheet. My formula is returning 0 and I'm not quite sure where the issue is coming from. =COUNTIFS({Accuracy Issue Tracker with Form Range 3}, [Billing Date Start]:[Billing Date Start] <=…
-
Assign individuals in set rotation
Hi, I have a contact list of 20 individuals that need to be assigned to a document review sheet as tasks are added. The goal is to have each individual assigned to 3 tasks and then it would switch to the subsequent person. Additionally, I would need the rotation to start over once we reached the end of the 20 individuals…
-
Formula for Status Balls
Hello! I'm hoping someone will be able to help! I'm trying to determine the total percentage complete of children under a parent category. Criteria for percentage complete using the status balls would be: Green = 1 (deliverable met) Yellow = .5 (deliverable partially met) Null/Blank field/no status ball selected = 0…
-
IF CONTAIN formula - Email Validation
I'm attempting what I'd consider a pretty basic IF CONTAINS formula, but I'm not getting the results I'm expecting. As an attempt to validate emails, I'm trying to use IF CONTAINS to turn on a flag when .com is not found in the email cell. "Your email" field contains email, which in input by the user via form. "NEEDS…
-
Referencing Another Sheet Formula For Text
I added a column in a sheet that is sourced from another sheet...it's for text not numbers. Which formula would I use for this one? The source correlates to the site name...I'm a little stuck. Thanks in advance!