Welcome!

Form get value as tekst from som users

I got a form and the value is present as text some on some users and as number on others.

Why is that ?

The calculations get wrong withe the texts.

Regards Jonathan

Forms

Formulas

Hi Jonathan,

It's probably that the cell is formatted differently in the sheet. Try to select the column and select the Thousands Format.

Please see attached link/screenshot.

I hope this helps you!

Best,

Andrée Starå - Workflow Consultant / Get Done

Image 2018-03-23 at 2.13.57 em.png

How to calculate the % of complete activities under each parent row.
Hi! I'm fairly new to SmartSheets but have been trying a number of things that havent yet worked. I want to be able to show for each parent row, the number of child rows completed as a %. So for the parent row Process Overview there are 7 tasks and 6 tasks are complete so I want it to show as 90%. Can anyone help me?
Join-Collect from dropdown?
I have a column named Territory, where I am trying to write a formula to populate it when names are chosen from an adjacent drop-down list column called Employee Attendee. If more than one name is selected from the Employee column, I would like their respective territories to populate in the Territory field, separated by a…
Formula Error multiple criteria
Hello, I am trying to find the average audit score for a range of percentages between two dates. There are divider rows for organization by month. I have been trying to utilize the following formula but continue to get #DIVIDE BY ZERO for an answer: =AVG(COLLECT([Audit Score]:[Audit Score], [Date of Chat]:[Date of Chat],…