-
Multiple dates from one row in calendar
Hi, I'm tracking clients in a sheet with about 12 different date columns per row. I'd like each client's name to appear on the calendar by every date listed in their row, but Smartsheet only allows one date column per calendar view. Are there any good workarounds for this?
-
Is there a way to get a single day calendar view
I am building a schedule of sorts for a multiple day event. Calendar view is only able to display down to a week. I need a daily view. This coupled with filters and reports will make the large volume of activities more customizable and easier to consume for clients.
-
Calendar Query - repeating item automation
Hi there Im creating a calendar for my team in SS - some items are repeating Weekly / Monthly / 1st Wednesday etc. How do I automate that rather than having to type each entry individually ? Thanks for your bright ideas 🌟
-
grey out specific number of days in calendar booking form
Hi, Is there a way to grey out let's say 2 days from the pop-up calendar so end-users cannot book equipment for 'today' or 'tomorrow'? For instance, today is 5th May and the calendar will show 6th and 7th as unavailable / not able to select for booking. Thank you in advance!
-
Is there a way to create 2 Reports from one Sheet with different formatting?
I am looking to create 2 Reports from one Sheet that contains employee time off requests. The Sheet contains 13 columns, but for simplicity, the relevant fields are as follows: Employee Name Division Start Date End Date PTO Used (# of hours) Approved? I would like to have one report for the managers to show Name, Division,…
-
Changing row information without adding a new row
I have a calendar that is populated by a Form submission. The information captured is an on-call schedule for our department doctors. Often times, the docs will end up switching on-call days/weeks. Is there a way to update the row they already have submitted (deleting/adding dates) instead of creating a new row?
-
Smartsheet Forms
Hello, I'm currently working on an events calendar and want to have a Form where people can submit event ideas or requests, i just want it to be sent to me and my team for approval instead of being added to my sheet. is there a way we can do this?
-
How can I visually show Phase dates on a calendar rather than just total dates like Gantt
We have several important phases for each project (i.e., Plan phase begin, plan phase end, test phase begin, test phase end, etc.). The Calendar app only lets you show the overall project dates in Gantt, and then we can shade. How would you suggest automating pulling the phases into child lines with just the phase dates -…
-
Mode date related features
When a date is changed on an action, we would like for SS to be able to determine if the new date is Before or After the initial date. This would be a real game changer for tracking projects deliverables.
-
Weekly rotating roles formulas
Hello, I am trying to create a report or calendar sheet with these weekly rotating roles: Weekly 1st shift Call Center (Mon-Sun) Weekly 2nd shift Call Center (Mon-Sun) Weekend On-Call 1 (Sat-Sun) Weekend On-Call 2 (Sat-Sun) I have a sheet with the list of [Name]s and a [Resource #] column to use for creating the rotation…