-
I am using IF, AND, CONTAINS - Result coming wrong
here the formula - the answer should False IF(AND( CONTAINS([ASSET NAME]@row, {A 2024 Range 3}), CONTAINS("INTERNATIONAL", {A 2024 Range 5}), CONTAINS([NAME HELPER]@row, {A 2024 Range 2}), CONTAINS("Completed", {A 2024 Range 4}) ), "TRUE", "FALSE") Any advice please :) Thanks!
-
Parse info found between the third quotation marks: {"id"=>abcd, "value"=>"efgh"}
Hello guys, Can you help me extract the info found between the third quotation marks from this? {"id"=>abcd, "value"=>"efgh"} The id can have either 3 or 4 characters and the info in the last quotation marks can have a different number of characters as well. I need to extract efgh. Do you have any ideas? Thank you!
-
Divide By Zero Error with Average
Hi, I'm trying to set up a formula that averages the scores for four columns, but doesn't bring up the Divide by Zero error if the scores haven't been entered yet (either leaves blank or puts a 0). The Average formula works fine but I can't get the IFERROR part to work. Current formula: =ROUND(AVG([LOR 1]1:[LOR 4]1), 1)…
-
Retrieve the date of checkbox marking
Hello! Can you please advise on how to retrieve the date of checkbox marking in the adjacent cell?
-
Formula Help
I have this formula: =IF(CONTAINS("Resource", [Component Type]@row), LOWER(Curriculum@row + IF([Grade/Level]@row <> "", ".g" + [Grade/Level]@row) + IF(Module@row <> "", ".m" + Module@row) + IF([Concept/Topic/Arc]@row <> "", "." + [Concept/Topic/Arc]@row) + IF(Lesson@row <> "", ".l" + Lesson@row) + "." +…
-
Formula for text string
OK, so I have a problem that I cant solve. I have a sheet that (in the example) lists students and their assessment dates. I have a column for student name, then columns for each assessment dates. I want to build a single column that lists in date order each students "assessment date: assessment" as per the example below.…
-
Join formula started adding a leading zero on text from certain columns
I created this formula, and it worked great the first two times it was used. The third time, it added a leading 0, which is NOT present in the [Circulation Requirement Details 3] column. I did further testing triggering the function using [Circulation Requirement Details 4] and [Circulation Requirement Details 5], and 0 is…
-
Unparseable for multiple IF statements
Hi, I'm trying to use multiple IF formulas within one cell by transferring from the Excel sheet I created it in, but I keep receiving the "#UNPARSEABLE" error code. Here is the formula I've attempted in SS: =IF([Support Intensity]@row="high", 9),IF([Support Intensity]@row="medium", 6),IF([Support Intensity]@row="low", 3)
-
COUNTIF where counting if cell contains "Super" but "Superstar"
I have a formula where I'm counting how many products are at a certain status and where they have a title of Super, Super & more or Super & Design (B&W) - but want to make it scalable. Is there a way to create a formula where I can tell it to count any cell where "Super" is the prefix? And secondarily, not count anything…
-
Unsure of formula or function to pull sales agent data from 2nd sheet
Currently we input all weekly sales results for our agents into sheet ONE named "2024 Agent Sales Activity" (1 row per agent with sales that week, with the primary column being the agent name "Last, First", and one of the other column is "Weekly Total"). In a SECOND sheet I'm setting up a lifetime sales tracker, with one…