-
Collect date on sheet 2 if tag on sheet 1 is contained within tag column on sheet 2
Hi, I'm stumped on a formula and hoping to get some help. I have 2 sheets; Sheet 1 is titled E&I and contains the tag number and Sheet 2 is titled Open PO's and contains the date the item is due and the tag number with additional characters in a single cell. I am trying to pull in the date from the Open PO report into my…
-
Formula to create "all that apply" for Knowledge Check Form
Hello Community, I am currently creating a knowledge check and was wondering if there was a formula to create an "all that apply" type of question. For example: 5. What is on the customer experience call flow? Smile Engage Trust Own Listen This is my broken formula: =IF(CONTAINS(("Trust", "Smile", “Own”), [5. What is on…
-
Formula with AND and OR
I'm fairly new to formulas. I created this one sucessfully so far: =IF(AND([Contract Status]@row = "Existing Contract", [Credentialing Status]@row = "Approved"), [Credentialing status: As of date]@row) So it takes the credentialing approved date from that 4th column and copies to the effective date in the 6th column (in…
-
Help needed with using VALUE function...
Hi All - I'm needing to convert Text to Number as intermediate step for another formula column in my worksheet. Have successfully used VALUE Function =VALUE(LEFT(Probability@row, 2)) This will work great until I get to 100%.... Help & advice welcome
-
IF, AND/OR, NOT formula with multiple conditions for a symbol column
Hello, I have been using a symbol column to monitor updates for a master sheet of all of my departments projects: =IF([Exec Summary Update]@row < TODAY(-14), "Red", IF([Exec Summary Update]@row < TODAY(-8), "Yellow", "Green")) However, I need to update this formula to include criteria that states NOT if the Phase@row is…
-
Use case Question
Hi community. I am working with @Laura Polson to help our field staff be able to track their schedules while out visiting stores for various reasons. We would like to find a way to show visibility based on hierarchy (district to regional to territory) for assigned stores. For example - if I am a District Sales Manager that…
-
Formula/Function to pull new rows/updated rows to another sheet
Hi Everyone, We have a critical issues list that is maintained by another group, and I've created an end-to-end schedule that will determine whether or not we will have the issues "validated" by our Week 0 deadline. Since the source sheet is constantly being updated and new issues are added weekly, I want my sheet to be…
-
Best way to calculate data across 100 sheets with same structure
Working on a project that will have 100 or so sheets with exact same structure. I need an efficient way to be able to calculate data SUM, COUNTS, AVG across 100 sheets in one metric sheet. What is the best way to accomplish this without the need to reference each individual sheet? Is there a way to run metrics on a report…
-
Struggling with Formula. Not sure if using correct one.
I have 2 sheets. We'll call Sheet A "Roster" and Sheet B "Grading Sheet" Sheet A has columns for "Employee Number" and "Email Address" What I am trying to do is on Sheet B, have a column in which you can enter the employee number, it reference Sheet A and then it will automatically enter the email address associated with…
-
Help with #Unparseable Formulas
Hi Everyone! I am a new Smartsheet user and am having some issues creating formulas that are based off of multiple columns where those columns are set up as drop downs with multiple selections. My Formula: =SUMIFS({Deliverables}, {Work Type} HAS (@cell, Reprint), {Fiscal Quarter}, HAS (@cell, "Q1"), {Fiscal Year}, HAS…
