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

Find more posts tagged with

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 do I include field changes in an email (Automation Question)
Hello: I am creating automations for several of my SmartSheet projects. I have successfully created an automation that alerts me when there are changes to any of 5 critical values in a row within my sheet. However, I am trying to determine how to include which of those 5 values changed in the alert email.
Countif with contains
I want to count the number of times the word Booth is contained within a row for each of my vendors on my sheet. There are other words in the row such as cancel or no show. I have tried =COUNTIF([May 11]@row :[Oct 26]@row ), CONTAINS("Booth", @cell) and =COUNTIF([May 11]@row :[Oct 26]@row ), CONTAINS("Booth", @row) and…
RBG and Gray Formula
Hi All, Can someone please help me correct this formula? The grey color is not coming up when the status is "on hold" and instead green is coming up =IF(Status@row = "On hold", "Gray", IF(Status@row = "Complete", "Green", IF([End Date]@row < TODAY(), "Red", IF([End Date]@row <= TODAY(14), "Yellow", "Green")))) Thanks