I want to create a multi-select dropdown list with all future dates and this will be sent out in a form. Currently, smartsheet only offers a date selector with one max date. I was wondering, is there a way to upload values into a dropdown through an API? Otherwise, can I upload values into a dropdown from another sheet?…
On the calendar view in smartsheet, is there a way to show more information than just what is entered into the primary column? For example, we have appointments that need to show who the meetings are with, who's invited, and the time and location at a glance on the calendar view, without having to click on the appointment.…
I would like to copy an existing calendar view and update the fields. However, I think I need to recreate it altogether. Is there a way to do this?
When a deal in my pipedrive reaches a new stage 'Job Scheduled' it automatically adds a new row to Smart Sheets with a Task Name and Duration. What I need Smartsheets to do next is automatically enter a starting and end date based off of the row above Predecessors and autofill a new Predecessors for the next row that will…
Hi, I'm new to Smartsheet and hoping that what i'm trying to achieve may be possible but have drawn a blank on the help and community topics so far. I need to be able to represent that a project milestone is landing in a specific financial quarter and then have this represented on the Gannt chart. Ideally i would have…
Hi hoping for any help I can get on this. Using the image as a reference. Im trying to make [Length score] show a number between 1-4. the scenario being if the length is 30 days or less it equals 1 and between 30-90 it would show a 2, between 90-150 show a 3 and between 150-365 show a 4. Would love any help on this people…
I am creating a customized dashboard for all of our stakeholders to view events and trade shows within their region. The main file is used by my team to plan all of these events and trade shows, so it has a lot of comments and attachments that I do not want to share with stakeholders. When I created a report to show the…
Hello! I work at a university. My team and I help coordinator several Dean's schedules and student meetings. The current process is extremely manual. Ex: Staff member is informed a meeting needs to be scheduled, staff member looks for openings, schedules meeting, sends confirmation email to the student and partner site…
Hi, I'm using Microsoft Outlook Calender for Work but I'm wondering is there any solution to sync my work Microsoft Outlook to Smartsheet Calender ? Meaning we send event invitation from Microsoft Outlook to my Smartsheet Calender and update in my Smartsheet calendar.