-
Pushing dates to calendar
Hi Can anyone help with a formula that only pushes a certain dates to the calendar? I want to publish only certain dates. I tried the filter but you can only set the default view on filter when sharing not publishing. Thanks Emma
-
Date validation
Hi... I tried search on validation of Dates, especially while selecting while selecting dates from form. I need to restrict use of past dates and user should be able to select dates which is today or ahead of today. Please suggest.
-
IF () formula, Change Status Dependate on Date
I would like to build a formula so that status will change to "Red" and type will change to "Renew" when date is past "Expire Date". I've applied the two formulas separately at the top of each corresponding column. But so far it just changes it to Red or Renewed automatically, without the date dependency. Can I make this…
-
Overriding Non-Working Days
Most of our projects include M-F working dates, however at the end of each project there is often a conference or event which may take place over a weekend or other non-working day. I'd love to be able to override and enter tasks on weekends for these instances without turning the entire project into a 7-day work week…
-
Set Return Date as today +5
hi there, i have a form to manage my graphic designer's projects. It includes a To Graphics date and Return to You date. How do I set the Return to You date to be today +5 or greater?
-
Calendar View - Click into Inforamtion
Hi I've built a number of calendars of a report but when i click on an event in the calendar to get the rest of the information its bring back all of the information from the original source. I only want the information which is in the report. How can i get the calendar just to show the detail on the report that the…
-
Adding Outlook calendar entries into a Smartsheet
Is it possible when creating a calendar entry within Outlook, to have that entry automatically populate a new row in a Smartsheet sheet?
-
Publish a shared google Calendar in a sight
Hi there, I've imported our team google calendar into a smartsheet no problem, and I can see all the entries, however when I try to present this in a sight the calendar grid is displayed without any entries. I've 'published' the source sheet with the calendar import, and both the source sheet and sight are shared with all…
-
Sunday IT operations
Hello, I would like to know if there is a way to force a task to be planned a particular day of week (sunday in my case) ? Saturday and sunday are not working days but for special IT operations we need to work a day off. Thanks for your replies.
-
Entering a Day of the Week Should Input the NEXT Occurrence of that Day
If I am working on my sheet on a Wednesday, and in a date column I enter "Monday", it automatically enters the date for the preceding Monday. It would be much more useful if it entered the date for the following Monday.
