Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
Apple Numbers : Common Syntax
##########################
# 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))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment