-
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…
-
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…
-
Using App to Schedule Resource
I am using Smartsheet to create a calendar system for reservation of a shared resource. So far, I have not been able to find a way to add TIMES to Smartsheet so more than one person can schedule the same resource on the same day, during different time slots. Can you help? Furthermore, these resources are occasionally…
-
Reports - Publish as iCal
Is it possible to publish reports as iCal? If not, this would be a great feature.
