-
If Formula Help
I need a formula to fill in a checkbox if the first name matches the first name of another sheet, last name matches, and it contains the position name Logistics. Thoughts? =IF([First Name]@row = {First Name}, IF([Last Name]@row = {Last Name}, IF(CONTAINS("Logistics", {Position}), "true", "false")))
-
Conditional Index Match
Hey y'all, I have a formula that does an index match to a separate sheet however, there are no unique ids that I could match. I have narrowed down the data to a point where if I could add just one condition to the formula I could get the information I need. The source sheet has thousands of rows and the target sheet has…
-
COUNTIFS not working
Hello, I have attempted to COUNTIFS from one smartsheet to another, however I have had no luck. Once smartsheet is being used to collect numbers and the other is getting information pulled in from Jira. As you can see in the screenshots I am trying to count certain words in text fields and not a matching character in a…
-
I need to determine if a date column is blank then it returns a message
Hello, I want help with a formula to return a message that says met goal if the date is blank or did not meet if the date is populated. I tried this formula but it is not working it returns #Unparseable =IF(ISDATE([Request Intake Range 9]1:[Request Intake Range 9]22), "met goal", "did not meet") So essentially I want to…
-
1 cell to many
I have a Master sheet where there is 1 cell with a multi-select that a user could choose a number of items. While I can reference that Cell, and wrap text to make it look like a list. I am ideally looking to see if I can break that cell into many cells. List column cell is "=[Multi Select]@row" with 'Wrap' on I'm in need…
-
COUNTIFS with 3 criteria
Hi I was wondering someone could help me figure out what is wrong with my formula. I'm trying to reference another sheet and produce a countifs figure based on three different criteria: Range 1: Type = Project Range 2: Category = Digital Range 3: RAG = Red This is my formula: =COUNTIFS({Children's Transformation Range 1},…
-
IF statement issue, can seem to get it to work
I can do it in Excel but cant seem to get it right in Smartsheet. I need to categorize for an age analysis - Current, 30 days, 60 days, 90 days etc. =if(([Aging Days]@row>30,"Current"),if([Aging Days]@row>30<60,"30 Days"),if([Aging Days]@row>60<90,"60 Days"),if([Aging Days]@row>90<120,"90 Days"),if([Aging…
-
Travel Ticket
Hello, Do i have the option to create a printable shop travel ticket/WO from an entry that's been created thru the online Forms. Right now we use Word to copy all needed info of smartsheet manually. Trying to automate this.
-
Time Sheet Formulas
With the help of this community and @Paul Newcome and @Andrée Starå I have created a weekly time sheet for my employees, that can display the day of the week given a date and calculate the hours worked in a day given in, out and lunch break times. The formulas work great! However, I have an automation set up that moves…
-
Date Formula Assistance
Good day, I need assistance in setting up a formula for tracking next service dates on equipment. I have two sheets - Sheet 1 is a schedule of Workdays and Sheet 2 is where the various equipment are listed with previous service dates etc. Sheet 1: Sheet 2: C3: Workdays: C1/C2 Question 1 C4: C3 + C7 (this must be based on…