-
Syncing Microsoft Outlook Calender with Smartsheet Calender
Hi, I'm using Microsoft Outlook Calender for Work but I'm wondering is there any solution to sync my work Microsoft Outlook to Smartsheet Calender ? Meaning we send event invitation from Microsoft Outlook to my Smartsheet Calender and update in my Smartsheet calendar.
-
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.…
-
Copy Date from Formula to another Sheet not working
Hello- I have one sheet with a Form attached. When users submit their form, I have a formula that will convert their some of their selections into start and end dates. Sheet 1 I then have a second sheet where all rows are copied from the first sheet that serves as a Calendar view for the created dates. I did this because I…
-
Use of Smartsheet for Preventive maintenance program
Hello, I looked at several tool to manage our maintenance program. We have several equipments with subcategory that I can organize with Parent and children relationship. I have a due date and a frequency of operation (industrial application: Replace hydraulic oil, replace wear plate etc). My plan: create 2018 maintenance…
-
Showing multiple dates from the same sheet row in a calendar
I have 6 columns in my Smartsheet that are date columns, two of which are start and end dates. I have got the start and end dates to appear in a calendar report, but the other ones (individual dates, not date ranges) do not show up. I cannot have them as children rows. I have tried applying conditional formatting to the…
-
Salesforce Integration- Worth it?
Hi everyone! We currently use Salesforce, Quip & Smartsheet however, we have not yet added the integration to sync them. Can anyone tell me what the huge advantage is to justify the price of the integration? The video links are a bit vague & I need to provide a few good reasons, other than an auto alert if a new…
-
Calendar View on Mobile App
I have a few questions about the Calendar View on the mobile app. I thought it was possible to view the calendar in a monthly format, but I can only see a weekly format on the mobile app. Is it possible to switch to a monthly view? Also, my filters don't seem to be applied in the mobile app, which makes the calendar very…
-
In Calendar App/Quarter View, can you change the Fiscal Year output of year? (Q1-FY2022 vs Q1-FY2023
Our fiscal year runs April 1-March 31. In the Quarter View, all events running April 1, 2022 through June 30, 2022 are showing up as FY2023. However, April 1, 2022 is the START of fiscal year 2022 for us. I would like the Quarter View to show it as FY2022 Q1 and not FY2023. Is there any fix for this? (See below. Events in…
