-
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…
-
Automatically Sort Data
Hi, Our team works with a spreadsheet which currently is updated quite often / simultaneously by several users. We have been facing difficulties whenever new information is added, since sorting is not properly adjusted until we manually select sorting, refresh and save the data. Is there a way to automatically sort…
-
How to print without Conditional Formatting?
I have a sheet with a lot of conditional formatting that must be printed in the gantt view without any of the formatting. So each week I have to disable all the rules, print, and then enable them again. It's tedious. There must be a better way. Any thoughts on how I can generate a gantt in a PDF without the rules and…
-
Auto populate data in other columns by selecting dropdown value in primary column
I'd like to select an item from the dropdown menu in my primary column, and have the two following columns fill with predetermined information. Example: We have 100 items. When I select one from the dropdown menu in column 1, the following two columns automatically fill in the prices associated with that item. Can this be…
-
Common formatting of Percent Complete.
Hi everyone - I like to format my rows so that things that are complete are green and things that are late are red. So I created some conditional formatting so that if a task was 100% complete then it was green and if it had a due date in the past and was not 100% complete it was red. I was pretty happy until I added some…
-
Formula Help
Greetings- I'm struggling with the cross-sheet referencing and need some help with a formula. I want to create a new sheet summarizing the values on a corresponding dropdown menu for the name and # of products we sell. I'd like the total number sold for each dropdown choice displayed on the new sheet. In the screenshot,…
-
Looking for Smartsheet Consulting Expertise - Charlotte NC or Atlanta GA
We are looking for a Smartsheet freelancer that can help develop additional reports and dashboards. Prefer local to Charlotte NC but open to telecommuting.
