In Spreadsheet.com, formulas can do more than return alphanumeric characters.
With formulas, you can output values that match any one of Spreadsheet.com's data types, including formulas that assign users, to attach files, link rows between worksheets, and more.
However, many of Spreadsheet.com's data types require different output syntax in formulas. For instance, when creating a formula that outputs Select data type values, your formula can output strings like =IF(A1=TRUE,"SelectOption",""). However, formulas that output user data types must reference a cell that contains the designated user (e.g. =IF(A1="Incomplete",F2,F3) with the F2 and F3 cells containing users).
Required Output Syntax for Each Data Type
In addition to the formula output syntax detailed below, cells containing the formula must be set to the corresponding data type. For instance, for a formula to output a currency value, the cell containing that formula must be set to a currency data type, or else the formula will simply produce a string.
Data Type  Required Output Syntax  Example  More Information 
Users  CELL REFERENCE 
=A1 
Assigning Users with Formulas 
Attachment (Files)  CELL REFERENCE  =A1 where A1 contains an attachment 
Attaching Files with Formulas 
Related Rows  CELL REFERENCE  =A1 where A1 contains a related row 
Assigning Related Rows with Formulas 
Text  ALPHANUMERIC STRING or CELL REFERENCE 
="Text to be entered" OR =A1 

Select  STRING or CELL REFERENCE 
="Select Option" OR =A1 
Assigning Select and Multiselect Values with Formulas 
Multiselect  CELL REFERENCE  =A1 where A1 contains the desired multiselect options 
Assigning Select and Multiselect Values with Formulas 
Number  NUMBERS, STRING, or CELL REFERENCE  =45
="45" =A1 

Currency  NUMBERS, STRING, or CELL REFERENCE  =100
="$100.00" =A1 

Percent  NUMBERS, STRING, or CELL REFERENCE 
=1/2 ="0.50" =A1 

Date  DATE SERIAL NUMBER, or CELL REFERENCE 
=43831.00 OR =A1 

Date & time  DATE SERIAL NUMBER, or CELL REFERENCE 
=43831.5625 OR =A1 

Duration  NUMBER or CELL REFERENCE 
=1.705 OR =A1 NOT "40:55:12" 

EMAIL ADDRESS AS STRING or CELL REFERENCE 
="email@newblend.com" OR =A1 

URL  URL AS STRING or CELL REFERENCE 
="spreadsheet.com" OR =A1 

Phone Number 
PHONE NUMBER, UNFORMATED STRING, or CELL REFERENCE 
=2125550100 ="2125550100" OR =A1 not ="(212) 5550100" or similar formatting 

Rating  NUMBER or CELL REFERENCE 
=5 OR =A1 

Icon Set 
Formula icon set output cell and icon set inputs must match icon set style ICON NAME AS STRING (like "Up", "Quarter", "Green", etc.) or CELL REFERENCE 
="Up" OR =A1 

Related Row Lookup  CELL REFERENCE  =A1 
Read on to learn more about working with Formulas and Advanced Data Types, including Formulas in the Primary Column and The Column Formula Data Type.