-
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…
-
CELL LINKING
I AM USING SMARTSHEET TO HANDLE MY BUSINESS, ie: TRAVEL AGENCY. I WANT A WAY BY WHICH ALL MY DRIVERS CAN UPLOAD ABOUT THEIR AVAILABILITY AND THEN ALL THESE THINGS COME DIRECTLY TO MY SHEET. AND THE DRIVERS SHOULDNT BE ALLOWED TO VIEW MY SHEET, FOR THAT I THOUGHT OF CREATING A SEPERATE SHEET FOR EACH AND EVERY DRIVER AND…
-
How to lock/unlock sheet in oder employees could modify it withing the given time frame?
Hello, I would appreciate your help to my question! :) Every month different teams need to input the information in a sheet within a given time frame, after deadline all information is extracted to pdf and shared with the rest of the company. Many often employees are changing information after deadline, which means that…
-
Standard Calendar layout template?
I want to explore using Smartsheet for editorial calendars. I'm having a hard time finding any templates that display as a monthly calendar with seven day of the week columns and rows for each week. Is this something that exists in Smartsheet or should I look at another option?
-
Integrate Shortlink generator with Smartsheet
Hi all, I use Smartsheet as a master content hub where content that needs to be promoted through social media channels are submitted by multiple users through the Smartsheet webform. After the submission, the content is compiled into the Smartsheet where it is posted to the proper social channel by an admin. I was curious…