Form submission with CAD currency as default

Roshni Verappan
Roshni Verappan ✭✭✭✭
edited 10/25/23 in Smartsheet Basics

My SS tracker has currency columns and I have set the columns as CAD however when I submit a new row using the forms it always enters the new currency as USD and then I have to go in and change the column again to CAD.

This is a painful process for the amount of submissions receieve daily and they will always be in CAD.

Can't I make the default for my sheet CAD including what is submitted using the form? Or is there another work around that someone has that can be used.

Thanks for any support on this.




  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭

    Hi @Roshni Verappan

    I hope you're well and safe!

    It should work as long as you have three or more cells with the same formatting and on the same level at the top or the end of the sheet.

    Can you double-check if that's how it is already?

    I hope that helps!

    Be safe, and have a fantastic week!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!


    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: | | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.