Can you restrict columns to write only time/contact?
I know that we are able to restrict columns to write contacts only. However, for some reason even if I have the contacts listed, they still write down their email instead of selecting the contact drop down lists. Why is it not restricting properly?
How would you restrict a certain column for the person to input time only (AM/PM only) format? I want to prevent people from typing in dates in that specific column instead of typing the date or anything else/military time.
Thank you for your time and help!
Best Answer
-
You're more than welcome!
Ok.
I recommend adding the time options in a dropdown and locking it so that the user can only select from that list.
07:00 AM
08:00 AM
09:00 AM
10:00 AM
11:00 AM
12:00 AM
01:00 PM
If the times can be anything, you could split it into multiple columns and then collect it together. (Hour, Minutes, AM/PM)
Make sense?
Would that approach work?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
Answers
-
Hi,
I hope you're well and safe!
It could be a set dropdown list with options, or you could have a formula check the structure and show a message if it isn't correct.
Would 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 comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
-
I have restricted it to contacts only, with names written already.
Do you happen to know how what formula to write to restrict dates only?
Thanks Andree!
-
Excellent!
Happy to help!
Here's how you can restrict the date column.
Would that work/help?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
-
No that doesn't answer my question, but let me rephrase it since I'm not doing a good job explaining. I have already restricted the date by selecting the arrow you pointed at for the date column. However, I am trying to restrict TIME (AM/PM ONLY) and not have any dates in another column at all written…
For example:
Time (AM/PM ONLY) Column
5/22/24 2 PM (Sometimes a person will write down date in the time only column when we don't want the date written)
Thank you for your help and time.
-
You're more than welcome!
Ok.
I recommend adding the time options in a dropdown and locking it so that the user can only select from that list.
07:00 AM
08:00 AM
09:00 AM
10:00 AM
11:00 AM
12:00 AM
01:00 PM
If the times can be anything, you could split it into multiple columns and then collect it together. (Hour, Minutes, AM/PM)
Make sense?
Would that approach work?
✅ Remember! Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives