-
Where did Publish to iCal go?
Reports in calendar view used to have a Publish to iCal tool easily available. After their last update, it has been replaced with filters and grouping tools. Where do I find the ability to publish calendars now? I can't seem to hunt it down. Publish seems to only have link options not necessarily calendar options. Please…
-
Exporting Calendar View to PDF not working
Hi, I'm trying to export my calendar view from the calendar app to a PDF, however it does not work; it briefly goes blank and returns to the view but does not generate a PDF. Can you help? Also, is there the ability to export this to Excel? Thanks~
-
Adding Months based on Calendar Days not individual days
I am looking for a formula that adds months to a date and keeps the "x" day of the month. Meaning if I am adding 3 months from February 1st, 2021, it would return May 1st, 2021 vs. just adding 90 days to February 1st and returning May 2nd, 2021.
-
Creating Due Dates (Monthly & Quarterly)
Greetings I have been asked by a colleague to build a smartsheet that sets out a list of tasks to be completed and the due date of each task (to be used primarily in calendar view by the colleague to plan her time). Her due date for a task is either made with reference to: (i) a business day in a particular month (i.e.…
-
Can I Highlight and/or use conditional formatting in the Calendar App?
Is conditional formatting, or highlighting, something that can be managed within the Calendar app. e.g. I have specific data from a dropdown column in my sheet displayed for each item on my calendar, but want to highlight the calendar item if it contains a specific dropdown [not using filters, as I still want all data…
-
Day of Week instead of short date
Hello, I would like to have a formula in place that automatically selects a day of week based on the date we paste in the "Bid Date" Column. When 3/26/18 is loaded into [Bid Date] Column it produces "Monday" in the [Day] Column, and so forth... Is this possible?
-
No 'Add New' appearing on the calendar app
I think it should be at the top left but I can't see anything!
-
Drag and Drop task using Calendar View
Hep! I am trying to drag and drop tasks using calendar view but it is not letting me. No error message just unable to move it.
-
Backups/Excel export
Hi all, Would it be possible to backup/export a spreadsheet on a scheduled basis more often than daily? One of the Departments on my company asked if it would be possible to do it hourly or even every 10min, but the smallest period i can find is daily...
-
Calculate new start time for whole schedule
Hi there! As an event organizer, I want to automatically update my schedule in smartsheet when a session takes longer than expected. Column 1: Start Time (HH:MM) Column 2: End Time (HH:MM) Column 3: duration in minutes Column 4: new start time (HH:MM) how can I arrange a formula so that once entering a new start time in…
