-
Automatic Timeline Changes
Hello! Newbie here to Smartsheet. I am working on a project that requires a timeline of multiple items with deadlines that are dependent one each other (i.e. can't start phase 2 without completing phase 1). What formatting can I use to automatically push back phase 2 and 3 if phase 1 end date or start date changes?
-
How to use Smartsheet to track and record appointments and events: third party app solution?
Hi, I am using smartsheet to enable a team of folks to collaborate on project managment. Our projects are organized into objectives, activities and events - each getting its own row and set of data for timeline management, allocating human resources, tracking deliverables, etc. Our team uses google calendar to schedule…
-
Is it possible to default to the calendar view rather than the grid view?
I set up a conf room reservation system using a report on top of a smartsheet. I've shared the URL with end users but sometimes when they follow the link it displays in grid view when I only want it to display in calendar view. Sometimes its correct and sometimes not which is causing headaches. Is there a way to force one…
-
Create birthday calendar with reminders - no year entry
We would like to use SS to create an employee birthday calendar and set the due date as their birthday - without using the birth year (so we don't have to recreate the wheel in subsequent years). If I set the birthday (date) column, I have no option but to use the current year. OR, once the sheet is set up, is there a way…
-
Modify Calendar View?
I'm trying to take a list of dates and associated activities - potentially up to 15 per day -- and display them in a calendar format...either traditional or agenda layout. I have curriculum maps -- material we will cover each day for 6-8 weeks - listed out in spreadsheet format and then want to turn that into something…
-
Conditional Formatting in Calendar Not Working on Refresh
I use conditional formatting to change the background color of certain items in the Calendar view. Smartsheet seems to have a bug where the conditional formatting works perfectly when going from the List view or Gantt view to the Calendar view, but when I refresh the browser within the Calendar view, the conditional…
-
Copy/Paste rows changed "created date"
I had to copy and paste a few rows within one of my sheets. When I did, it changed the "Created" date and time to when I pasted the rows. How do you ensure that this column always reflects the proper date, if rows have to be copied and pasted? Thanks K
-
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
-
Why does moving a subtask or milestone in the Gantt view preserve durations...
but rekeying an end date alters the durations? I'm using predecessors and start-to-finish dependency to work backwards from a deadline for a task. The durations for subtasks must remain fixed. If I type in a new deadline for the task, the durations adjust—this is not what I want. If I slide the deadline in the Gantt view,…
-
Universal Date Setting for Date fields
Can a Universal Date Setting be added to Smartsheet settings please?
