Poka yoke to enter time with character only:

Adilson Mota

I also have another problem that I can't fix the format of typing the time, not allowing other characters in place of :

Poka yoke to enter time with character.JPG

when typing in the form, there is no poka yoke to put only:

Andrée Starå

Hi @Adilson Mota

I hope you're well and safe!

Unfortunately, it's not possible now to format for time, but it's an excellent idea!

Please submit this as a Product Feedback or Idea (If it hasn't been added already) when you have a moment.

Here's a possible workaround or workarounds

• Add a formula to check the format and if it's not correct you could trigger an automated Update Request asking the submitter to update it.

Would that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

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!

Adilson Mota

Andrée thanks about your retorn.

I included the idea.

have a nice day and week.

Andrée Starå

@Adilson Mota

Excellent!

Happy to help!

✅Remember! 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!

Adilson Mota

Hello Andrée

I need your formula.

How do i put the Sumif form in the same smart i different columns.

because I'm doing it and the error.

This is the formula I'm used.

=SUMIF([Qtde total de Golpes por ferramenta]@row, Ferramenta@row, [Total de Golpes Final]@row)

the error message is #calcular reference

Adilson Mota

https://community.smartsheet.com/discussion/103542/poka-yoke-to-enter-time-with-character-only

Hello time..

First of all excellent New Year "2024" for ours.

About the question above the calculate the time.

Poka Yoke time calculation.PNG

We have a poka yoke about it?

Because example attached I need ever week to fix this appointment production.

Thanks