-
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?
-
How to highlight a date in a column based off of another date
Id like to highlight Column (Date Sent to Owner) in reference to Column (Due Date). If we hit the targeted Due Date, before or on the day that it is due- I would like Date sent to Owner to be highlighted green, if I we exceeded that date or it is past due, I would like that to be highlighted Red. Is this possible or is is…
-
Inventory checklist
I have to create an inventory checklit based on an Excel document I will have 2 main sheets: Inventory & Picks Inventory will have a list of all the SKU/units that we have per product. Picks will need to offer me the option to select one item from the Inventory sheet and once I pick it, it has to tell me if we have enough…