-
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.
-
Conditional formatting if task is behind schedule
Hi guys, I'm new to Smartsheet so forgive me to ask the question. How do I setup conditional formatting to a task that is behind schedule? I created 2 lines of conditional formatting already: 1 ) task is 100% complete -> green row 2) end date is in the past and % complete is not 100% -> red row I'd like to add a third…
-
Enhancement feature - Merge Cells functionality
Wanted to start a thread for an enhancement feature to try and push this up in the road map prioritisations. For such a simple and standard feature in tools like Excel and Google Docs it has become such a barrier during the process of trying to migrate exsisting documents form the above tools to Smartsheets and now is…
-
Calling All Email Marketers - Approval Workflows with Smartsheet
Any email marketers use Smartsheet to manage their email campaigns? I'm trying to create a workflow to gather approvals, lists, etc. and to stay organized! Can anyone share examples (screenshots) of how you set up your sheet to stay organized with your email campaigns? Do you use forms and alerts/notifications? Thanks!
-
Form Field to Comments
Is there a way to have a field on my form that would input the text to the comments for that row?
