Poka yoke to enter time with character only:
I also have another problem that I can't fix the format of typing the time, not allowing other characters in place of :
when typing in the form, there is no poka yoke to put only:
Answers
-
I hope you're well and safe!
Unfortunately, it's not possible now to format for time, but it's an excellent idea!
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Andrée thanks about your retorn.
I included the idea.
have a nice day and week.
-
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!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
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
-
Hello time..
First of all excellent New Year "2024" for ours.
About the question above the calculate the time.
We have a poka yoke about it?
Because example attached I need ever week to fix this appointment production.
Thanks
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives