-
Need a Column Property type that is "clock" or "time of day"
As an event management company, we have on-site event schedules that require a "start" and "end" time column. Those columns need to reflect the time of day and currently we have to create a whole drop down list of 24 hours to choose from for those columns. Am I missing it if it already exists? Or, if not, it would be great…
-
Using Google Calendar shared with me
Hi, I've tried and successfully implemented the feature of publishing to Google Calendar. However, it requires that the target Google calendar be a calendar that I own, rather than one that is shared with me even though the shared calendar grants me editor rights. Is there a work around?
-
Dashboard
I am trying to create a widget on Dashboard for project progression that includes factors such as "Total development cost to date" "Total development cost this calendar year" "Future spending in next 1,2,3, months". How do I program the cells in sheets to reflect these dates (ie. todays date plus 20 days for next months…
-
Multiple date ranges for one row?
Wondering if it's possible to add more date ranges for a single row, so that multiple occurences of one task will show up in the gantt view. I'm trying to create an advertising schedule for various events, and each ad runs multiple different times during the lead up to each event. I'd rather not create a separate row for…
-
Generate list of recently updated sheets
I would like to have a quick readout of the five or ten most recently updated sheets from WorkspaceA or WorkspaceA --> Folder5 I can build a report that grabs all of the sheet rows by updated in the last 30 or 60 or 3000 days, but how can you get a list like: * FinanceSheetXYZ updated Yesterday by John Smith *…
-
applying vacation or unavailable time to resources
Hello, I am an MS project user and in that program you could denote unavailable time for resources so when a task assigned to that person fell on an unavailable time period, the start and end dates accomodated for that automatically. Is there a way to do that in SS? thank you, Karen
-
Feature Request: Calendar View wrapping of Task Name
The Calendar View would be much more useful to some of us if there was a way to wrap the Task Name so that the whole Task Name was readable, as opposed to the truncating that currently occurs. Thanks!
-
Auto Assign a Predecessor in Gantt
Hi, I have a series of standard processes that have the same dependency and predecessor data each time. I have the primary column as a job number, and then a second column with a drop down list of all the standard processes (I.e. assembly, pre-assembly etc.). If pre-assembly is selected, for example, I always want it to…
-
Date Calculation Question
Can anyone share with me on how I can calculate what I call the 'Next Quarter Projects'? For example: I have a start date and end date columns for each project, and I want to create a Filter/View that shows me the projects that are due in between a date range(ie Q2, Q3, Q4, etc) Can anyone help? Thanks!
-
Row or Record roll up and multiple forms or sheets
I have been attempting set up a relational database for multiple client use. This database should track records (rows including child rows) as it progresses through different phases. Projects may stop periodically and should be searchable and may be re-started later. I have tried using 3 column relational connection to…
