Using Smartsheet Forms
I have this schedule above (took out the names/privacy) for weekly schedules with my team. Normally there is a time frame in each cell for thee week like 9:00-5:00. Each week pulls down, I just have week 3 as an example.
And this form:
Is there a way that I can have someone enter in their information, for example if someone wants to take leave on 11/21/20, and have it correspond to the cell with the specific date instead of just the days of the week in the column? Or would that require something more along the lines of a formula/function/conditional formatting?
I currently have it set up to change the color of a cell if it has "leave" "call out" "off" etc.... but would like to be able to have someone fill out the form and be able to put "leave" and have it correspond to the cell which would then replace the times and just have "leave" and the color it changes to.
I hope that makes some sort of sense, I'm having trouble putting my thoughts on this into words.
Best Answer
-
Dear Addison Spencer,
hope you are fine, you can use the template called "Employee Attendance Taker" in Smartsheet templates as a base for this work it will solve what you need.
Best Regards
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
Answers
-
Dear Addison Spencer,
hope you are fine, you can use the template called "Employee Attendance Taker" in Smartsheet templates as a base for this work it will solve what you need.
Best Regards
bassam.khalil2009@gmail.com
☑️ Are you satisfied with my answer to your question? Please help the Community by marking it as an ( Accepted Answer), and I will be grateful for your "Vote Up" or "Insightful"
-
That does seem to be something that could work, but is it the only thing? I'd rather use what I already have rather than try and fit what I need into something that only kind of works and I'd have to change things anyways.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives