-
Formula for progress bar based on RYG balls
Hi, Is it possible for the progress bar to represent the amount of progress based on RYG balls. EG/ if red = 0%, yellow = 50% and green = 100% the progress bar would be an average of how many of each colour there were? Thank you
-
How can I run a report that includes the sheet owner as a column next to the sheet name?
I need to send a job list to one of my suppliers. I have multiple project managers working on construction jobs, and they have a sheet for each project. Each sheet can have 3 or 4 tasks for one supplier - such as for plumbing work - and I want to create a report that shows the sheet name (which is the construction…
-
Justify Column Names
Hi SS users, Is it possible to centre justify the name of my columns..... Minor detail, but makes my sheet look messy. Cheers, Kylie
-
Linking Cells from Columns to Rows / Transpose Paste Special
I am trying to copy data from a source sheet to a destination sheet. The data on my source sheet is in columns, but I want it to be shown as rows on my destination sheet. I have tried to link several cells at a time, but it only links one cell - not the group of cells. So... I tried to bring in over as column to column and…
-
Adding branding to emails
Hi, We use update email requests a lot and would prefer these to look like they are from our compnay and not from smart sheet. This helps when we are sending these to external people. Is there a way to do this? Thanks
-
About Auto Reminders
Hi Community ,I have an Invoice sheet w i manage i auto Repairs shop on wheels Receivables I have an Invoice sheet tracker I have an Invoice sheet where I have the following columns a column "service date " date type a check column type "send invoice " a check column " completed " and Description of service as a text type…
-
Is there a way to add hours and minutes in a column?
This is the only thing holding us back form using smartsheets. Is there a way to add columns such as the one in the attached picture and come out with the correct answer for hours and minutes?
-
Rounding ONLY Up
Hello, I have a construction equipment management sheet and I am trying to create a customized rounding formula for the "months rented" cell. Equipment rentals usually charge at intervals of 1-week, after that at 2-week, then after that at 1-month. Because of this, having a value like "1.3 or 1.6 months rented" doesn't…
-
Expanding and Collapsing Hierarchy/Outline levels
Very much would like to have the ability to expand the hierarchy to a particluar level such as 1,2,3 ... ALL. For my applicaiton Level 1 is PROGRAM, Level 2 is PROJECT, Level 3 is milestone, etc. I need to see the entire sheet open to a particular level. Looking for something that exists in Excel as well as all "outline…
-
Try out upcoming Smarsheet features
Update: We have all the responses we need at this point. Thanks everyone for your input! We'll keep you posted the next time we have early features to show you. Best regards, Daniel -------------- Hi all, We're working on new features in Smartsheet designed to help you stay on top of work requiring your attention. We'd…