-
If its Blank Formula
Hi There, I need assistance on ItsBlank formula. Formula I currently have that isn't working =IF(ISBLANK([Other Concerns]@row), [Name of Company]@row + "presently had no other comments or concerns.").",If [Name of Company]@row="1" +[Name of Company]@row+ "also responded that"+[Other Concerns]@row)) My Output information:…
-
#REF in the formula when I move data to archive sheet
When I transfer completed orders from the working sheet to the archive sheet, I encounter a formula error in calculating the final stock. Before moving the data: =[Initial Stock]@row - SUMIFS([Total Quantity Requested]$1:[Total Quantity Requested]@row, Collected$1:Collected@row, 1, [Item_ID]$1:[Item_ID]@row, [Item_ID]@row)…
-
How to use INDEX(COLLECT) for two criteria?
I am trying to use INDEX (COLLECT) to match information from two columns to turn out a result in the third column. This is just a demo (actual variables are different) but here is the general format I'm going for, where I want to get the "occasion" result in a separate datasheet based on the information in "clothing type"…
-
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…