-
Formula to add a number in a cell based on other figures
Hi hoping for any help I can get on this. Using the image as a reference. Im trying to make [Length score] show a number between 1-4. the scenario being if the length is 30 days or less it equals 1 and between 30-90 it would show a 2, between 90-150 show a 3 and between 150-365 show a 4. Would love any help on this people…
-
Hide comments and attachments on calendar embedded on dashboard
I am creating a customized dashboard for all of our stakeholders to view events and trade shows within their region. The main file is used by my team to plan all of these events and trade shows, so it has a lot of comments and attachments that I do not want to share with stakeholders. When I created a report to show the…
-
Calendar/Form Integration and Automatic Emails
Hello! I work at a university. My team and I help coordinator several Dean's schedules and student meetings. The current process is extremely manual. Ex: Staff member is informed a meeting needs to be scheduled, staff member looks for openings, schedules meeting, sends confirmation email to the student and partner site…
-
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…
