Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
filling columns -has to be a better way!
I have a schedule with close to 2000 lines. I am adding columns that need calculations in them. It currently takes me close to 15 min to either drag the formula down or copy and paste chunks. When I create the column why not provide me an option to enter the formula then and apply that to every row? Smartsheets has been…
Parent Row Symbols based on highest priority?
It is possible to create a formula that will change the symbol to represent the HIGHEST level out of the 4 rows? IF the (HIGHEST) Risk Level for rows 1-4 is "x" THEN action for symbol column is "low" = blue symbol is "medium" = green symbol is "high" = yellow symbol is "extreme" = red symbol I currently have a formula to…
Change branding logo interaction
Currently, clicking on the branding logo (now in the upper left) opens the Home tab view in the same location as last visited. This is duplication of the functionality when clicking the Home tab directly below the logo. Two suggested alternatives: 1. Open the location (Workspace or Sheets) for the active Sheet or Report.…
Displaying current user in Sights
Is there a way to display the current user's name in Sight. I am building a dashboard which needs to show the logged in user's name and data associated with that user. I can display the data using a report that filters data for the current user based on values in a column( of type contact list) but cannot use the same…
Add another column/type of data to my Gantt chart?
Hi there, I'm trying to figure out a way to add another column's info to the Gantt chart. For example, we're tracking my org.'s grant cycles. So for the Primary column, I've used "Organization Name " for the funder (i.e. Hewlett). For the label, I've used program (which program the grant is for, i.e. Environmental Equity).…
Change Column Name in Multiple Sheets
Is there a method to change column names in multiple sheets? (I'm aware of the impact on reports that include those sheets.) It is very labor-intensive to change the column names in multiple sheets, but that is how we work in the real world. Change, change, change. I've already updated the template, but wow what a pain to…
Attachments need to be attached to an email not linked
We would like to be able to send an email encompassing a couple of rows with attachments (Invoices). The recipient of the email needs to be able to access the invoices as attachments as a computer reads them to populate their accounting program. The computer is unable to read the invoices if they appear as links to…
Emailing reports, except for when blank
I have a report pulling data from several sheets inside my workspace. Essentially it emails the report as an attachment every morning at 9am to my team and lists out open project needs. The question is there are some days when the report is blank (ie. no open project needs). Is it possible to: * not send an email if report…
speed of sheet
I solved it never mind. Thanks if anyone was looking at this. I have a sheet that is moving very slowly, in fact the entire page doesn't seem to work when I have the sheet open. It is less than 30 columns and 100 rows, however it has many lookups and column references due to the nature of what I am trying to do. below is a…
Multiple Check box columns with Harvey ball formula in symbol column.
I have four columns set to check boxes. How do I set the formula to show the empty Harvey ball if none of the check boxes are checked, a quarter Harvey ball with one check box checked, a half Harvey box with two check boxes checked, a three quarter Harvey ball with three check boxes checked and a full Harvey box when all…
