Smartsheet Guru Blog
Smartsheet Parent Cell Checkbox Value Based on Children or Descendant Checkbox Cells
https://youtu.be/Dzo0UYjxMmI In Smartsheet you can have a parent checkbox cell change value based on Children or Descendant Cells. Formula using Descendants Function:=IF(COUNTIF(DESCENDANTS(), 1) = COUNT(DESCENDANTS()), 1, 0) Formula using Children...
Parse Smartsheet Multi-Select Dropdown Column Into Individual Cells
https://youtu.be/U12LwTrXwoQ Below are the Formulas I used for this sheet by Column:Quantity Fruits Selected:=COUNTM([Fruit Multi Select]@row) Fruit 1:=IF([Quantity Fruits Selected]@row > 3, "More than 3 Selected", IF([Quantity Fruits Selected]@row = 1, [Fruit Multi...
Smartsheet Wrong Date Shown Using System Created Time Date in a Calculation
https://youtu.be/S-GsCr9wA5g
Smartsheet COUNTM Function
Smartsheet COUNTM Example