Can you restrict columns to write only time/contact?

Newcomer2 · 05/22/24

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!

Andrée Starå · 05/22/24

https://community.smartsheet.com/discussion/comment/437363#Comment_437363

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!

Andrée Starå · 05/22/24

https://community.smartsheet.com/discussion/122333/can-you-restrict-columns-to-write-only-time-contact

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!

Newcomer2 · 05/22/24

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!

Andrée Starå · 05/22/24

https://community.smartsheet.com/discussion/comment/437326#Comment_437326

Excellent!

Happy to help!

Here's how you can restrict the date column.

Screenshot of Arc at 22 May 2024 at 19_27_41.png

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!

Newcomer2 · 05/22/24

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.

Andrée Starå · 05/22/24

https://community.smartsheet.com/discussion/comment/437363#Comment_437363

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!

Can you restrict columns to write only time/contact?

Best Answer

Answers

Categories