Fix for currency entries using forms

Heidi Muller

HI. We have multiple sheets with currency columns. When submitting a new form entries the new entries does not show the currency in the respective currency formulas - only the value.

Is there a fix?

Thank you 

Andrée Starå

Hi @Heidi Muller

I hope you're well and safe!

As long as one of the below conditions is met it should work.

Automatic formatting or autofill for formulas is applied when specific conditions exist in the sheet. Note that it is possible to override these changes when they occur.

Conditions That Trigger Automatic Formatting

You’ll see automatic formatting occur when you type in a newly inserted or blank row that is:

• Directly between two others that have the same formatting applied.
• At the topmost row of the sheet if it's above two others that have the same formatting applied. (This includes rows inserted from a form.)
• At the bottommost row of the sheet if it's below two rows that have the same formatting applied. (This includes rows inserted from a form.)
• Above or below a single row that is between blank rows and has formatting.
• Example:

Did that work/help?

I hope that helps!

Be safe, and have a fantastic week!

Best,

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å

@Heidi Muller

More info:

https://help.smartsheet.com/articles/1641473-auto-filling-formulas-and-formatting