-
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…
-
My Smartsheet Wishlist
I wish, I wish upon a sheet that these will someday be a reality...if some of these are already posted, I apologize... Product team - most, if not all, of these were sent to Scott Willeke verbally or via e-mail so he could lend more context. These items are some of the things that would make Smartsheet even smoother.…
-
Calculate number of days in a month
I'm trying to build a custom calendar in a sheet (Calendar app or view doesn't work in our use case), I want to calculate total number of days in a given month, but so far the day, date formulae need two set of dates. I know one way of simply declaring the values in a column and use it that way but I was wondering if…
-
Suggestions for display of a calendar
Hello, I am working to create a call room reservation request system for our hospital. Smartsheets is working wonderfully for this, I'm just stuck with one little dilemma. The people who review registrations, like to be able to view the month at glance for all the rooms reserved. The screenshot below shows our current…
-
Volunteer Allocation
Hi All, I am attempting to find a solution for a specific manual task that is error prone and very time intensive - We need about 300 volunteers occasionally on short notice and need them across multiple cities in 20-50 specific locations (we do not know these specific locations until last minute). I have built a survey…
-
Cannot transfer ownership of Smartsheet Calendar
I am trying to transfer ownership of a Smartsheet Calendar to a coworker, but when I try, it is giving me an error message, saying that the user isn't found and new user needs to be shared to the source sheet/report as an Admin in Smartsheet. I have checked, and this coworker is already an admin in all of the source…
