Apple Numbers : Common Syntax

apple_numbers_syntax.scpt

##########################
# DATA REFERENCING
##########################
# Is this word duplicated anywhere in a column of this sheet?
IF(COUNTIF(A,A1)>1,"Yes","no")

# Grab values from the another sheet
SheetName::Table 1::$A1

# Is this word duplicated somewhere in another sheet?
IFERROR(IF(MATCH($A1,SheetName::Table::A,0),"yes",),"no")

# Does this word exist in the a different, specified sheet?
IFERROR(IF(MATCH($A1,SheetName::A,0),"yes",),"no")

##########################
# MATH
##########################
# Rounding up cells in a column
ROUNDUP('A:A' $A1,0)

# Count the amount of words in a cell
LEN(A1)−LEN(SUBSTITUTE(A1," ","",occurrence))+1

# Count the characters of a cell
IF(LEN(A1=0),LEN(A1),"")

##########################
# CONCATENATION
##########################

# Using cell values and to make a list with a "," delimiter.
CONCATENATE($A1,", ",$A2,", ",$A3,", ",$A4,", ",$A5,", ",$A6)

# Grab cell value, target what character to replace, then enter a character to replace it. Entering "" removes the character.
SUBSTITUTE(CONCATENATE(B2),CHAR(40),"") SUBSTITUTE(CONCATENATE(C2),"ReplaceMe","") SUBSTITUTE(CONCATENATE(D2),"ReplaceMeToo","") SUBSTITUTE(CONCATENATE(D2),CHAR(41),"") SUBSTITUTE(CONCATENATE(F2),"s","")

# ----------------------
# URL Concat Example
# ----------------------

(* The etsy query url as a cell variable. It lives as a header column (B1)
https://www.etsy.com/search?q=
Grabs the keyword, and replaces them with the %20 characters (since that's how Etsy handles spaces) then throws the result at the end of the url
*)

SUBSTITUTE(CONCATENATE($C$1,B1)," ","%20")

# Remove Double Quotes
SUBSTITUTE(CONCATENATE($A$1,A1),CHAR(34),"",occurrence)

##########################
# CONDITIONALS
##########################

# If a cell has content
NOT(ISBLANK(A1))