Timezone

Allison Capra

Allison Capra ✭✭

12/04/20 in Formulas and Functions

Hello -

I am hoping someone can help me. I need to show a created date field that is currently in EST to Atlantic Standard Time (AST) - can someone assist with a formula

0 ·

Answers

Paul Newcome Community Champion

12/04/20

There is a link HERE that has a timezone conversion solution. Feel free to take a look and let me know if you need any help getting it to fit your needs.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10x Time Savers (An exclusive group that grants you access our Smartsheet master classes, tips, tricks, & much more!)
Training opportunities with my team and I
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

Count HAS Function Between Dates
I have worked to find a solution out there but not getting one that works. I am collecting data from a sheet to be used in charts on a dashboard (so referencing another sheet). The result will need to be generated from two columns Date - date the project closed Fund - The fund/funds used to pay for the project (multiselect…
Multiple IF Statements Using "ISDATE"
I have an existing formula that enters text based on two criteria: if a date exists in a column, and if that item was closed prior to the anticipated delivery date. The current formula is: =IF(ISDATE([Closed Date]1), IF([Delivery Date]1 > [Closed Date]1, "Complete", "Fail")) I'd like to add an additional criterion that…
Formula
I am trying to identify how many surveys taken at the start of the program are from the Jacksonville market using this formula =COUNTIFS({Time of Survey}, {Time of Survey}, "Week 1 of program", {Data}, "FLJAC Jacksonville") but it retuns as Incorrect # of arguments