Format of column not reflected on completed form

Genevieve Van Buhler

We have a smart sheet that is created when a form is completed. There are multiple columns with the currency format (i.e. $25.00), we created the completed form to generate with additional fields our employees enter. However, the amounts that are formatted as currency on the sheet is not keeping the format and looks like 25.0. Any suggestions?

Andrée Starå

@Genevieve Van Buhler

Got it!

Unfortunately, I don't think it's possible to get the same formatting in the form at the moment.

Please submit an Enhancement Request when you have a moment

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Genevieve Van Buhler

Start with making sure that the following conditions are true.

The new row will be auto-filled with the formulas if there are two rows below/above with the same formulas and the same level of hierarchy.

More details:

If the formula structure is the same above/below the Formula Autofill will add the formula(s) automatically.

Conditions That Trigger Formula Autofill

You’ll see formulas populate automatically when you type in a newly inserted or blank row that is:

• Directly between two others that contain the same formula in adjacent cells.
• At the topmost of the sheet if it’s above two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• At the bottommost of the sheet if it’s below two rows that have the same formula in adjacent cells. (This includes rows inserted from a form.)
• Above or below a single row that is between blank rows and has formulas.

More info: 

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

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 help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Genevieve Van Buhler

The formulas are populating on the new rows correctly.

Here is a screen shot of the column and a few rows of the sheet:

Here is what that same field looks like in the completed form: the dollar sign isn't showing and the 2nd decimal isn't showing, should be $249.80.

The formula that we are using to create the completed form is:

="https://app.smartsheet.com/b/form/xxxxxxxxxxxxx?Title%20Company%20Name=" + SUBSTITUTE([Title Company Name]@row, " ", "%20") + "&amp&Title%20Company%20Attention=" + SUBSTITUTE([Title Company Attention]@row, " ", "%20") + "&amp&Title%20Company%20Address=" + SUBSTITUTE([Title Company Address]@row, " ", "%20") + "&amp&Title%20Company%20Phone=" + SUBSTITUTE([Title Company Phone]@row, " ", "%20") + "&amp&Title%20Company%20Email=" + SUBSTITUTE([Title Company Email]@row, " ", "%20") + "&amp&Service%20Address=" + SUBSTITUTE([Service Address]@row, " ", "%20") + "&amp&Closing%20Date=" + SUBSTITUTE([Sewer Amount]@row, " ", "%20")

Andrée Starå

@Genevieve Van Buhler

Got it!

Unfortunately, I don't think it's possible to get the same formatting in the form at the moment.

Please submit an Enhancement Request when you have a moment

✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!