Smartsheet Lookup a Value in Another sheet based on Multiple Criteria

by darren | Aug 21, 2021 | Smartsheet Functions, Smartsheet Tricks

This video shows a simple example of how to pull in a value from one sheet into another using more than one criterion. The collect function can collect values based on multiple criteria, then the join function displays it as a text value.Formula used (The value in {}...

Smartsheet Count Occurrence of Contact In a Multi Contact Column

by darren | Aug 21, 2021 | Smartsheet Functions, Smartsheet Tricks

This video shows you how to count the occurrence of a specific contact in a multi contact column. This example shows how tasks John Smith, Joe Smith, and Smartsheet Guru are assigned to. Forumula used is: =COUNTIF([Person’s Assigned]:[Person’s Assigned],...

Smartsheet Name and Email Columns to Contact List Column

by darren | Aug 21, 2021 | Smartsheet Functions, Smartsheet Tricks

Learn how to take a Smartsheet column containing a name and another column containing an email and then combine these 2 columns into a Smartsheet Contact List Column Type Below if the formula used in this video. Note the space before the opening angle bracket=Name@row...

Smartsheet Custom Auto Increment Format

by darren | Aug 21, 2021 | Smartsheet Functions, Smartsheet Tricks

In this example a Auto-Increment ID is generated in the format AA001 AA999 then rolls to AB001, etc. with a maximum value of ZZ999 Here are the formulas used: Starting in the first row:3 Digit Number:=IF([Number Increment]@row = 0, 0, IF(MOD([Number Increment]@row,...

Smartsheet Wrong Date Shown Using System Created Time Date in a Calculation

by darren | Aug 6, 2021 | Smartsheet Functions, Smartsheet Tricks