-
How do you copy an existing calendar and adjust the different fields?
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?
-
Pipedrive + Smartsheets
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…
-
Representing Milestones landing in Financial quarters
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…
-
Formula to add a number in a cell based on other figures
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…
-
Hide comments and attachments on calendar embedded on dashboard
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…
-
Calendar/Form Integration and Automatic Emails
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…
-
Formula to check a box depending on start & end date
Hi all, I have 2 date columns (start date & end date) and 2 checkbox columns (live & concluded). I want to have the checkboxes automatically check and uncheck depending on the dates. For example: I have an event that runs from 12/2 through 12/4. On 12/2 I want the "Live" column checkbox to check and stay checked until the…
-
Filters for Calendar View in Mobile App
Not being able to use filters in the calendar view on mobile app is really a hinderance - especially because the filters are meant to help clean up the data so you only see what you need to at certain times. Where screen space is limited in the mobile app (more so than desktop) it seems odd this feature doesn't already…
-
Add Tasks to Calendar View in a sheet
Currently, we brainstorm tasks using a Quip calendar and then manually transfer the tasks to a Smartsheet project plan for tracking. We find that for group meetings, positioning tasks on a Monthly Calendar is an easier, more understandable way to visualize a series of tasks. Within Quip, we view a month-by-month calendar.…