Creating Project Timeline Visualizations-Not Gantt View
I am wondering if anyone has experience with creating a high-level project timeline view to put on a dashboard--and I am not talking about a Gantt view. What I am trying to do is avoid my customer from having to continue producing PowerPoint slides manually of the data they are managing in Smartsheet. Ideally, they would…
Extract Date from Modified Date
I am trying to use the Modified Date column in formulas. For some reason, it doesn't appear that this was created as a "Date" column type. Because of this, it cannot be used in any formulas that would allow a date. Is this assessment correct? Also, is there a way of pulling the date out? I've pulled out the Month, Day, and…
Parent Row Only Report
Is there a way to build a report consisting of only parent row information? I am trying to show overarching HR Processes in my sheet (parent row) without pulling in the sub-tasks. I tried a checkbox report but the sub-tasks are still showing up in the report although they were not selected. Perhaps there is a workaround or…
Is there a way to edit the Details Panel Layout for Calendar App entries?
I have text fields where the text extends the size the of the box, thus, not showing all information to shared users when they view the details of calendar entries. Similar to how one is able to determine what fields are shown (and how) in the Details Panel Layout for entries in the Dynamic View app, is there a way to have…
Calendar Invite Automation
Is there a way to send automated calendar invites to something like Google calendar (preferred)?
Desk reservation form
Hello, How do I create a form that will allow a user to reserve a desk for a particular day and remove that desk from a list of available desks? Within the same form, I will also need to allow for recurring dates? For example: If an employee comes to the office every Tuesday and Thursday, they could reserve that desk for…
Is the calendar sync still only a one way export? Is there anyway I can link my smartsheet calendar to Outlook and then share this with others? I have used the iCal function and this has created a new read only outlook calendar that I can not share with anyone. While calendar view is still not available on the mobile app I…
Any recommendations for third party form builders with advanced date field functionality?
I'm looking for a third party form builder that integrates well with Smartsheet, and provides additional functionality around date fields. We need to be able to easily restrict dates based on pre-set deadlines (i.e. report requests cannot be made for any date less than 12 business days in the future). Ideally we'd like…
Calendar issue when using multiple reports
Hi all, I'm experiencing a bit of an issue with calendars on a dash, and would appreciate some suggestions or help. I've got a source sheet for team-specific dates (let's call this source 1, although I have one for each team), and a source sheet for generic dates applicable to all (let's call this source 2). Then, I've got…
Updates not syncing with a GANTT chart to Google Calendar
Hi all - I have created a calendar in my Google account using the URL from the 'Publish to Calendar' function on my Smartsheet. However when I update my Smartsheet and save, it does not automatically update in the Google Calendar I have created. I've refreshed the calendar a few times but the new additions / updates to my…