-
Three levels of detail on single calendar view
All - We have data that is organized into a Target->Category->Item hierarchy, for example: Target: Big Event in Las Vegas Category: Digital Blogs Item: Blog about XYZ There is a "Target Date" for the top level Target, and an item "Due Date" for individual items. I am trying to fashion the data in a calendar view so that…
-
Rollup Calendar View
All - I am trying to find an easy way to "roll up" detail we track in a calendar view to show a summary view of the data. We are tracking deliverable assets for a marketing organization, which are organized by Target (Release XYZ) and Category (Buyers Journey Stage X). Other attributes include due date, owner, team,…
-
Can I show form users a calendar BEFORE having them fill out the form?
Hey, slightly complex question: my marketing department services several companies under our corporate banner, and we would love a way for end (form) users to see a calendar of scheduled communications before requesting a new one. We're hoping that showing stakeholders our already-full calendar of communications will…
-
Calendar view
I am trying to view a sheet in calendar view that covers the whole year at a glance...I'm pretty sure it's not possible but I'm hoping I'm wrong. Can anyone help?
-
Need help adding reminder date to a column
I have reminder set on various rows in the sheets in my Smartsheet. Is there a way to have the "date" that is set on each reminders displayed in a column on the same row? In the attached screenshot... Row 1... the reminder in the "i" column is set for Wed, 12/27. The project isn't due until Fri, 12/29. But the next…
-
"Save As New" doesn't retain Auto data...
I use a separate sheet to track projects in each calendar year. This means I need to carry over partially completed projects rows from the previous year's sheet to the next year's sheet. I've used a "Save as New" to duplicate the sheet, formatting and data, but my "Submitted" column which contains the "Date Created" now…
-
Form Submission Organization in Sheet
Is there a way to automatically move a new form submission to a nest under a particular row? For instance, I have 4 parent rows that nest several rows underneath and would like any form submissions to automatically be assigned under one of those 4 parent rows based on information that's submitted (if this, then nest under…
-
Default Styling for Form Submission
Is there a way for form submissions that get added to my sheet to automatically adhere to the stylings of the sheet? It's been a little annoying to change the fonts and sizes each time...
-
Completed date stamp formula runs when sheet is saved every time
Hi Smartsheet community, I currently have a formula the runs when a column drop down is selected to "Completed" =IF(Status4 = "Completed", TODAY()) However, every time someone else saves the sheet, the formula runs again and overwrites the old stamped date. This never happened before and I would like to know if there are…
-
Submitting Product Enhancement Requests
I understand that by submitting a "Product Enhancement Request" it doesn't mean it will be actioned and even if it is, will materialize in the immediate future. I think that rather than it them seemingly disappear down a 'black hole' a published list and the status of requests would be useful.