-
Formula to check whether or not a cell has been hyperlinked
I am trying to create a helper column that checks whether a cell in a nearby column ("Project" in this case) has been hyperlinked or not. I want to return 1 if True or 0 if False. Something like this: =IF(CONTAINS("http", Project@row), 1, 0) However, when I hyperlink using the menu dropdown (see attached image), this…
-
My Today Formula is coming up as #Unparseable ...
=SUMIFS(Mission:Mission, [RLO Receive Date]:[RLO Receive Date], ≥TODAY(-360)) Not sure what Im missing here? Anyone had any advice?
-
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…