Dynamic view - date format converting from UK to US

Dan Harris
Dan Harris ✭✭✭✭✭
edited 12/16/20 in Formulas and Functions


Dates are being converted from UK format in the report to US format in dynamic view, cannot see anywhere in settings to change, can you help?




  • Purnima Gore
    Purnima Gore ✭✭✭✭✭✭

    Hi @Dan Harris

    Yep, was a nightmare for me as well :-)

    If you use a helper column for the date so for example start has the date, the helper column is called Start Date - use the formula =DateOnly(Start) and then use that in the dynamic view.

    Choose this in the main view with the columns.

    If you want make it editable (so you can change the date) show that in the data tab, and it will give you the UK version to change to but the view in the main sheet will be from the helper column.

    All the best


    Purnima Gore

    Cierr Limited

    Your Time is Important, you want to Stay on Track, We can help you use the Right Tools


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!