-
Re: February Question of the Month - Join the conversation and receive a badge
Badge Collector would be fun.2 · -
Re: How to incorporate HAS or CONTAIN in my Index/Match formula?
"Tile" would change to HAS(@cell, "Tile")1 · -
Re: Capabilities of "Viewers" in new Model
Viewers will not be able to edit or otherwise interact with (beyond viewing) any asset directly. To edit an asset, they would need to have access to one of the tools listed in your original comment. …1 · -
Re: JOIN only if cell is not blank
@PeggyLang =JOIN(COLLECT(Name:Name, [EVEN MTH WK1 TOC]:[EVEN MTH WK1 TOC], @cell <> ""), "delimiter of choice")1 · -
Re: Date Dif Formula
Smartsheet does not have a DATEDIF function at all. We have to write our own formula to mimic. Something along these lines should work: =(YEAR([End Date]@row) - YEAR([Start Date]@row) - IF(MONTH([End…1 ·