by darren | Jan 3, 2023 | Smartsheet Functions
This video gives a demonstration of using the ANCESTORS() and PARENT() functions to reference multiple levels of hierarchy. As promised in the video, here are the formulas: Level column formula: =COUNT(ANCESTORS()) + 1 Project – Task Group column formula:...
by darren | Aug 21, 2021 | Smartsheet Functions, Smartsheet Tricks
I ran into an issue with Tableau bringing in data properly from Smartsheet when I had a combination of numeric and alphanumeric values in one of my Smartsheet columns. In order to ensure that Tableau recognized all the values as the same data type of string, I created...
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 {}...
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],...
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...
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,...
