Using Smartsheet Forms

Addison Spencer

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.

Bassam Khalil

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 Khalil

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

Addison Spencer

https://community.smartsheet.com/discussion/comment/269202#Comment_269202

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.