-
Date Calculation
I have 3 columns. 1 column is the date that the time begins, the 2nd is a factor that is either 1.5, 3 or 5. It is always one of these three numbers. The 3rd column is for the end date that is auto-calculated by taking the date in column 1 and multiplying it be the factor selected in column 2. How do I do that? I am really…
-
Push to someone else's Google calendar
How can I push a task to someone else's Google Calendar?
-
Building sheets that talk to each other
Hello, I have two sheets I would like to reference data to and from and I understand how to us the =VLookup option BUT what I cant seem to get it to work. I basically want one sheet that our shipping team updates to automatically update another sheet my purchasing team uses. The columns have dates and check boxes so when…
-
Calendar - How Do I Add Times for start and end of meetings, etc.
I'm new to SS and cannot yet figure out why the calendar doesn't allow me to display start and end times for meetings, etc. Is this possible? If so, where is this done? All I see is date related not time. Thank you!!!
-
Google calendar tab hyperlink from home page
Mike here from Australia - can you tell me is there a way to hyperlink from the Smart Sheets home page I want to make a google calendar tab that hyperlinks directly to my google calendar and not via a cell in a sheet - see attached image and tab, I would like to be able to click the tab to open an external link - any way…
-
Calendar App: why can't I see settings?
First let me say that we're new to the Smartsheet Calendar App. I started the Calendar worksheet but my manager wanted a chance to set-up the Calendar App this time around ('cause it's fun). Even though I'm the owner on the worksheet (she's the Admin - see attached screen shot), I cannot edit the settings in Calendar App…
-
Sheet Name Appearing within Google Calendar Milestones
I understand that when publishing to Google Calendar the Smartsheet Name appears as the Calendar Name. My scenario is this: I have 5-10 projects going on at one time for one given client. So, if I am viewing all calendars at one time, the tasks/milestones are difficult to differentiate. Is there a work-around so that the…
-
Publish Calendar View
Is there way to publish the calendar view only? I am needing to share just a bit of data in a calendar view only without sharing the entire sheet. Thank you in advance for any help.
-
Turn off display of weekends on Calendar view
I do not want weekends to display on the Calendar view of a task list, but I don't see any way to do this in the properties. How is this accomplished?
-
FS date calculation issue
I have the following calculated task dates in a gantt chart: Task no. Duration Early start Early Finish Dependency 22 60d 1-Feb-2021 23-Apr-2021 23 60d 29-Jan-2024 19-Apr-2024 22FS+720d (See attached screenshot) Task #23 is supposed to start 720d after #22 has finished. But if you manually check the number of days between…
