Published By
Created On
3 Jun 2021 23:45:19 UTC
Transaction ID
Cost
Safe for Work
Free
Yes
Smartsheet Wrong Date Show Using System Created Time Date in a Calculation
You may find when performing date calculations in Smartsheet on Smartsheet System generated columns such as Created (Date) and Modified (Date) that the result is not what you expect. This is due to Smartsheet storing system generated columns as server time (UTC or GMT timezone) but displaying it as your local timezone within your Smartsheet view.
In my video is a nice little workaround. I like to call these sorts of workarounds "Smartsheet Gymnastics"
This issue is described in more detail on the Smartsheet community here:
https://community.smartsheet.com/discussion/19461/wrong-date-showing-seems-to-be-4-hours-off-the-difference-between-gmt-and-my-time-zone
In my video is a nice little workaround. I like to call these sorts of workarounds "Smartsheet Gymnastics"
This issue is described in more detail on the Smartsheet community here:
https://community.smartsheet.com/discussion/19461/wrong-date-showing-seems-to-be-4-hours-off-the-difference-between-gmt-and-my-time-zone
Author
Content Type
Unspecified
video/mp4
Language
English
More from the publisher
Controlling
VIDEO
COUNT
Smartsheet-COUNTM
This video shows how to use the COUNTM Function in Smartsheet to count the number of items chosen in a Multi-select Dropdown column.
Transaction
Created
1 year ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
PARSE
Smarsheet-Multi-Select-Parse
This video shows how to Parse selections in a Smartsheet Multi-Select Dropdown Column into Individual cells within a Smartsheet
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 Select]@row, IF([Quantity Fruits Selected]@row > 1, LEFT([Fruit Multi Select]@row, FIND(CHAR(10), [Fruit Multi Select]@row)), "none selected")))
Fruit 2:
=IF([Quantity Fruits Selected]@row > 3, "More than 3 Selected", IF([Quantity Fruits Selected]@row = 2, SUBSTITUTE([Fruit Multi Select]@row, [Fruit 1]@row + CHAR(10), ""), IF([Quantity Fruits Selected]@row > 1, LEFT(SUBSTITUTE([Fruit Multi Select]@row, [Fruit 1]@row + CHAR(10), ""), FIND(CHAR(10), SUBSTITUTE([Fruit Multi Select]@row, [Fruit 1]@row + CHAR(10), ""))), "none selected")))
Fruit 3:
=IF([Quantity Fruits Selected]@row > 3, "More than 3 Selected", IF([Quantity Fruits Selected]@row = 3, SUBSTITUTE([Fruit Multi Select]@row, [Fruit 1]@row + CHAR(10) + [Fruit 2]@row + CHAR(10), ""), "none selected"))
Transaction
Created
1 year ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
SMART
Smartsheet-Parent-Checkbox-Value-Children-Descendants
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 Function:
=IF(COUNTIF(CHILDREN(), 1) = COUNT(CHILDREN()), 1, 0)
Project Status Column Formula:
=IF([Task Complete]@row = 1, "Completed", "In Progress")
Transaction
Created
1 year ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
SMART
Smartsheet-Form-To-Dashboard
Hi! I wanted to showcase an example of what is possible to do in Smartsheet utilizing a customized intake form with conditional logic, generating metrics with summary reports and a metric sheet, then showing the metrics on a Smartsheet dashboard.
If you'd like to reach out to work with me on a Smartsheet project, contact me on my website:
https://www.smartsheetguru.com/contact/
Thanks for watching!
#Smartsheet #Forms #Metrics #Coaching #Productivity #smartsheettutorial #howtousesmartsheet
Transaction
Created
1 year ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
SMART
Smartsheet-Custom-Auto-Increment-Format
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, [Maximum 3 digit value]$1) = 0, [Maximum 3 digit value]$1, MOD([Number Increment]@row, [Maximum 3 digit value]$1)))
ID
=CHAR([First Letter]@row) + CHAR([Second Letter]@row) + IF(LEN([3 Digit Number]@row) = 1, "00" + [3 Digit Number]@row, IF(LEN([3 Digit Number]@row) = 2, "0" + [3 Digit Number]@row, IF(LEN([3 Digit Number]@row) = 3, [3 Digit Number]@row)))
Starting in the 2nd row:
First Letter:
=IF(AND([Second Letter]1 = 90, [3 Digit Number]1 = [Maximum 3 digit value]$1), [First Letter]1 + 1, [First Letter]1)
Second Letter:
=IF(AND([Second Letter]1 = 90, [3 Digit Number]1 = [Maximum 3 digit value]$1), 65, IF([3 Digit Number]1 = [Maximum 3 digit value]$1, [Second Letter]1 + 1, [Second Letter]1))
Number Increment:
=[Number Increment]1 + 1
http://www.smartsheetguru.com
Transaction
Created
1 year ago
Content Type
Language
video/mp4
English
Controlling
VIDEO
SMART
smartsheet-Name-Email-Columns-Contact-List-Column
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.
=Name@row + " <" + Email@row + ">"
https://www.smartsheetguru.com
Transaction
Created
1 year ago
Content Type
Language
video/mp4
English