-
Calendar integration for Outlook (2010 et al.)
Hi, We use Smartsheet as an events listing and it would be useful to have integration to Outlook through a calendar. At the moment it displays rows as an all day event it would be beneficial for it to use the time fields we input so that it gives us a true indication of the event timeframe.
-
Date format inconsistencies, US/UK
If you copy and paste US-format dates (mm/dd/yy) into a Smartsheet while your personal settings are English (UK) (and presumably other Anglophone options), the data will retain the US format for all dates below 13. Where the date is 13 or more, Smartsheet will automatically transpose the format to dd/mm/yy. This can be…
-
Cashflow Overview from Date columns
Hi all, i have checked almost every single discussions, but still looking for my solution: Case: building houses with 6 payment steps from our customers (revenue), and consider 6-8 payment steps for our contractors (cost) Note: this part we are able to do 1.) finally have a mastersheet with follow columns: January-December…
-
Summary Tasks Show in Google Calendar
Even if I uncheck "Display Summary Tasks" on the Calendar settings, Google Calendar shows the summary tasks from my smartsheet. Is there a way to prevent these summary tasks from syncing to Google? Thanks for any help! Best, Max
-
Formatting Date in Smartsheet with Month Name Displayed
When using the column type of "DATE" the only way dates are always displayed as numeric values. However, some of my colleagues are requesting that the dates be displayed as Feb 12, 2016 or 12 Feb 2016, etc. Is this possible in Smartsheet? The only preferences I have located are the user preferences where you localize your…
-
Remove Parent Row from Calendar
Is there a way to remove the parent row or hide it from the calendar? I am working on a project sheet for a group with many workstreams. The parent row is the title of the workstream and I would prefer if the workstream did not show up on the calendar. It takes up too much space and it will not allow me to color code it on…
-
Import calendar into Lotus Notes
My organization uses Lotus Notes and I need to be able to sync the Lotus Notes calendar with smart sheet but have not been able to find any information on how to do that.
-
function dates difference
Hello there! I am trying the function =TODAY() - [starting date]3 and I am receiving this number as result: 86.7854 how can I obtain jus a round number of days?
-
% Complete and Durations
* Hi, I am a recent user of SmartSheet and was unable to find an answer in any of the current help venues. My apologies if this is duplicated elsewhere. Here is the situation I am facing: - I have a task with a two day duration. Let's say it was set to complete yesterday. - Today, I am told that the task is only 50%…
-
Virtual Time Cards - Contractors Working Remotely - Timecards
We manage a group of independent contractors that work off site. We are looking for a design of a web form so they can record the hours worked daily. This would have to allow for start time, lunch time (punch out), lunch time (punch in), and end time. Looking for a formula to calculate the hours worked daily, weekly, and…
