-
Smartsheet Calendar unable to update health status on source sheet
Hi, I created a Smartsheet calendar organized by Phase and then Workstream, with deliverable bars spanning duration. The goal is to create an interactive Gantt chart, which team members can update tasks on the calendar detailed side panel. The formula on the source sheet states that if At Risk is checked then Health is…
-
Calendar View
I am wondering if there is a way to have more than the primary field show when you are in calendar view. I would like the Primary and another field (Auditors) to be combined and show via the Start and End date. Fields: Project (Primary) Start Date End Date Auditors
-
Publishing calendar timing
I recently discovered how to publish a calendar to iCal in outlook. Does anyone know how to change the event from a full day to a block period of time? Thanks for any advice
-
Issues with Calendar view and hidden data
I have a calendar on my dashboard, and when primary entry for each row is selected it hides the data. I looked in the setting and I don't see a way to turn this interactivity off, any suggestions? Also I can't seem to get a row of data to come back in full view. If I flip the view so primary is going horizontal across the…
-
Standard Work Plan - Planned Vs Actual completion
Hi - im trying to create a standard work plan for Supply Chain tiered meeting. I want to build a calendar of activities that occur every month / quarter etc and specify how long they should take in mins / hours / days, and create that as a template for the users to see whats due and when. Then i want them to be able to…
-
Calendar View
In the Calendar View, is it possible to see the information in the primary key and another column?
-
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 🌟
-
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.
-
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?
-
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,…
-
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?
-
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?
-
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…
-
Scheduler in Smartsheet
I am designing a Scheduler in Smartsheet. It will be location and then have a central report view to see the whole schedule. Has anyone done this in Smartsheet before and can share some lesson learned or other knowledge points that would be helpful?
-
more options for Calendar Default View in dashboard
I'd love the option to change the default view of a calendar in a Web Content widget on my dashboard! (I am linking a sheet, not a report.) Option to choose the default layout (currently defaults to 1 month, and it would be so nice to choose the default view!) Option to choose what filters are on or off (currently defaults…
-
Time slots on calander?
We have a machine we want our coworkers to start requesting, daily and hourly. So if Joe wants to use the machine, he could go to the calendar and see an empty time slot between 1pm-2pm and he would be able to block that time out. Does smartsheet have anything like that? Kind of like an outlook calendar
-
Automation to Auto-Collapse a Row
It would be great if you could set up an automation to auto-collapse a row based on a status or a date that is in the past. I use a grid and calendar to breakdown payroll deadlines and reminders for a whole year and the sheet can get pretty big so having a rule that will auto-collapse rows when something is completed or…