Allow data entry only if another column is not empty
Hi everyone,
To help you understand, our business is about rentals. In our sheet, we have columns for:
- Date the contract was issued
- Date "from" (when the rental starts)
- Date "to" (when it ends)
I am trying to find a way to allow Data entry in columns 2 & 3 only if there is a date in column 1.
If column 1 is empty, employee should not be able to fill in column 2 & 3.
I have read about dependencies but it seems to only be helpful for cell automations which is not really my goal here as "date from" and "date to" are random.
Would you have any advice on how I could achieve the above?
Many thanks for your help
Laureen
Answers
-
Hi @Charter YPI
You can either add conditional formatting/message that shows that it shouldn't add data before the first column is filled.
Another option is to add it through a form and use conditional logic, and set the other fields as required.
Make sense?
Would any of those options work?
I hope that helps!
Be safe and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
-
Hi Andree,
Thank you for your quick reply!
I have tried conditional formatting + adding a description but mistakes keep coming up.
Can a form be used to complete information in a row instead of creating a new row?
Thank you! :)
-
You're more than welcome!
Could you use an Update Request instead?
✅Remember! Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. 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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!