-
How to move information with a workday function?
I work for a bath remodeling company and we have installers with level 1, 2, 3 based off skillset. I need a way to plan availability based off the amount of installers we have and their levels. Right now the date column reads, =WORKDAY(TODAY(0), Label@row) and this allows the dates to update automatically. I originally had…
-
How to Incorporate Durations in COUNTIF formulas with Calendar App
Hey all, I am having issues rolling up calendar availability with the durations. If you look at the calendar attachment picture, I want to have 3 jobs scheduled for 7/17/21 but we have a job with a duration of 2 days the day prior which makes it more like 4 jobs scheduled. I have a cross-sheet reference off the main…
-
Moving up start date on calendar app
When I move the start date backwards on the calendar app, I have no issues. However, when I try to move up the start date past the end date, I receive a message saying, "End date must be greater than or equal start date". Shouldn't the end date just follow the start date if I have project settings enabled? I have the sheet…
-
How do i create a calendar within forms that will block off certain dates?
I have created a form that I am using to send to people to sign up for something. I need them to be able to select a date, but have some that aren't available to be crossed out. Some dates will be able to have about 10 people sign up for, so that date will need to be crossed out once that limit is reached.
-
Calendar View Report
Is there a way to show multiple date columns in Calendar View on a Report? I have multiple columns selected but only one is pulling through.
-
Smartsheet calendar in google calendar for non-smartsheet users; changes not reflected
I'm trying to find a way to add a smartsheet calendar to my team's google calendar where if I make changes to the event dates on the smartsheet calendar, they would also be reflected in google calendar. If my team subscribes to the smartsheet calendar via URL, they don't see changes made after they've subscribed to it. My…
-
automation to update a date field to new value
Hi, I am trying to set up an automation where it detects when a date found in column DATE is passed and then would automatically update it based on the value found in the column frequency for example : if the DATE = 01/07/2021 and the frequency = Weekly then when we pass the date 01/07/2021 it should automatically change…
-
How to add card and calendar view on Dashboard
Hi there, I want to add a few sheets in card and calendar view on a dashboard. Is this possible? I only see that reports can be added on dashboards, how do we also add sheets. Thank you, Esperanza
-
Date Formula Issue
=DATE((YEAR[Tactical Training Start]@row), (MONTH[Tactical Training Start]@row) + 1, (DAY[Tactical Training Start]@row)) ^^ This is the formula as it sits now. I'm trying to take the date from the Tactical Training Start column for a cell and add 1 month to the date for a different cell. What am I doing wrong?
-
Android calendar view looks different than iOS
Since a few months ago, our Android users have been reporting an issue with viewing calendar events where events are shown as ellipses, as opposed to showing event detail. I've attached a screenshot of each view, showing the Calendar view of one of our Smartsheets. Any ideas?
