Operators & Functions in Calculated Columns

Last Updated on:
January 28, 2025

Purpose

This is a table overview of operators and functions available for use in Calculated Columns with certain data types. For more detailed explanation of operators and functions, consult Alchemy Script User Manual (Link)

‍** Functions calculating the value of all rows in one column

***Returns the number value as an output; number type of data should be selected

Related:
System Specifications
Create a Heatmap
Create a Boxplot
Create a Bar Chart
Create a Scatter Chart
Utilize a Sample Label Record
Save a Record as a PDF
Using Search Functionality
How to Add Fields to Material Search in Workspace
Create a Record from a Task
Link a Record to a Task
Share a View
View Record Edit History
View Field Edit History
What are the recommended devices for Alchemy use?
Which browsers are supported for Alchemy use?
Sign Out of Alchemy
Alter View Data
Clone a View
Create a Board
Create a Grid View
Visualize Data in a View
Add a Calculated Column
Group Data in a View
Apply Filters to View Data
How to manage columns in the View?
How to add other data in the View?
How to pull more data in the View?
Manage a Created View
How to create a NeCreate a New Vieww View?
How to copy/paste values from fields?
Utilize Spell Check
Open Link in a New Tab
Change the Task Completion Deadline
Start a Task
Delete a Value Chosen in a Dropdown
Change a Value Chosen in a Dropdown
How to View, Delete or Download attachments?
How to clone rows in compare?
How to add new rows in compare?
Export a Record
How to clone a record?
How to find record(s) shared with me?
How to share a Record?
Troubleshoot an Invalid Record
View a Record within its Process
Open a Standalone Record
Open a Pop-up Record
Follow/Unfollow a Process
View Files Attached to Process Records
Restart a Process Put On Hold
Put a Process On Hold
What Sign In Options are Supported for Alchemy?
Initial Sign-In to Alchemy
Upload a Profile Photo
How to use Dashboard?
Find Active Tasks
View and Use Notifications
How to Add (Multiple) Attachment(s)?
How to Edit attached images?
Use the Process Navigation Panel
How to export table from a record?
How to import from file?
How to compare and clone records?
How to compare existing records?
Complete a Task
Log Effort for a Task
Dismiss a Task
Reassign a Task
Add a New Task
How to resolve a comment?
How to check existing comment(s) on the Record?
How to add comments?
How to get more information about linked records?
Delete a Record
Print a Record
How to copy information from an existing record?
How to add New Record (i.e. Company, Contact, Product, Formulation, etc.)?
View Who is Associated with a Process
Check a Process Flow
Adjust the Target Completion Date from the Process Timeline
View the Process Timeline
View Two Records Side by Side
Void a Process
Change a Process Priority
Create a New Process
Reset Password
Enable Notification Settings
How to find information needed?
© 2017-2025, Alchemy Cloud, Inc. All Rights Reserved. Confidential & Proprietary. Not for redistribution.. Legal Terms

We use cookies to operate this website, improve its usability, personalize your experience, and track visits. By continuing to use this site, you are consenting to the use of cookies. We also share data with our social media and analytics partners. For more information, please read our updated Privacy Policy.

Accept