-
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.
-
Show date as day of the week
How can I use this forumla =TEXT(A3, "ddd") ?? This formula calculates the day of the week for the date and returns the abbreviated name of the day of the week (Thu). Every time I try to use this formula, it says "not recognized".
-
Color Palette
OK, So I figured others might find this useful. I couldn't find it, so I made it by exporting the palette from SS into Excel and divining the numbers. It's the RGB color scheme for Smartsheet for Excel 2013.