-
Parent RYG(B) status balls automated based on Child status
Hello, I have been scanning the community and have found some bits for what I am trying to do but am struggling to put it altogether and was wondering if anyone could help? I have a list of tasks with headers (parents) which then have sub tasks (children) and some of them also have sub tasks (children again i believe). The…
-
How to convert dates to Long Form Date format?
I understand that date formatting is normally set in "Personal Settings" but in order for the SmartSheet Merge to work for a problem I'm trying to solve, I need to convert the date to the long form (February 11th, 2016 instead of 11/02/16. Is there a script or IF statement that I could use to make the change? Thanks, SRC
-
Date modified in specific cells
Hi All, I am seeking a solution. Is there any way to have the date modified only show for specific cells? An excessive amount of clutter and information is shown by having the dates in each cell. Thanks,
-
How do I find a smartsheet expert for hire to help build out our workspace?
I am building out a new workspace for some large marketing intergration projects. I am way over my head with smartsheets, but I have used it to complete amazing M&A sheets. I want to start intetegrating smartsheets into the operating side instead of just the due diligience side of the business.
-
Task bar conditional formatting for calendar view (non defined task lengths)?
Hi guys I'm trialling out smartsheet as a content calendar, and as such I'm only including one date (publish dates) - so the sheet won't work as a gantt (which is fine) HOWEVER, I would need to apply conditional formatting to calendar view (to create an automated colour-coordinated content calendar) but it seems I can't do…
-
Being able to choose multiple choice in dropdown list
Hello everyone - I am trying to have it so that I can choose multiple options in a dropdown menu for a cell. Or someway that I can have a list of things in a cell. It is for tracking blog post categories. Thanks - Carlyle
-
CONDITIONAL FORMATTING FOR DATE TYPE CELL
Greetings I need to apply conditional formatting to a date type cell. I need to write a formula such that, when a the target number for a certain task has been reached, the deadlines for the next target has to be set. For Example, if the target for task A has reached today, then the start date for the next task should be…
-
Possible to strip cell formatting out for reports?
We're trying to generate multiple reports from a master smartsheet that we use to track various projects. As part of using the master smartsheet, we have certain practical cell formatting options we use to easily see progress or potential trouble spots at a glance (e.g. color coding certain cells base on conditional…
-
Copy & Paste Conditional Formatting to Another Sheet - Request
While starting new projects in Smartsheet via a template is great, I often have to start a project by importing an MS Project file. This means that I have to replicate all of the conditional formatting that we use on all existing Smartsheet sheets. Since we take advantage of the good conditional formatting options that…
-
Auto change a cell based on a checkbox in a different cell (all in the same row though) or change in
I created a pretty intense sheet to keep track on invoices and receipts. I have an "Action" column that is a drop down column. Here are a few of those "Actions" Request Sponsorship Submit Sponsorship Request Invoice Call to pay with CC Call back to pay Submit Check Request Follow-Up Check Approval Mail Check Out Request…