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
Can't get column data from more than 1 sheet
I am trying to prepare a report filtering information from 2 different sheets, and I need 2 columns from each sheet. When generating the report only data from one sheet is reflected in the report and the columns from other sheet are blank. What should I do.
Conditional Formatting Based on 2 Different Cells
I have done this in Excel but can’t seem to get it to work in SS. I need conditional formatting to represent the following: EAC Margin < BL Margin BL Margin ≤ EAC Margin ≥ (BL Margin + 5%) (BL Margin +5%) < EAC Margin Tried creating a separate column with a formula using IF. But can’t seem to get the formula to work. I am…
Numeric Column Type
Has anyone noticed that the alpha/numeric column doesn't sort properly when numbers are in the following format: 1.5.1.1, 1.5.11.2...........11.5.11.40. You get this: 1.5.11.1 1.5.11.10 1.5.11.11 ... 1.5.11.2 1.5.11.20 1.5.11.21 ....... 1.5.11.3 1.5.11.3 1.5.11.31 ... Would a purely numeric column type take care of this…
Possible to share filters?
I have created quite a few saved filters. (I am in love with this new functionality by the way.) Now, I want others to be able to see these saved filters and apply them while they are viewing my sheets that are shared with them. Is it possible to share filters? How?
Web form with restricted access
Hi all, I want to use a webform to collect details from my employees prior to their individual one to ones. They would recieve the webform on a monthly basis to complete. I would add any agreed actions to the sheet so we have a record. However, the information will be confidential and I don't want one employee to know what…
Sights Templates
will there be Sights templates added?
help with double counting please
Dear clever people of planet SS, please see SS: https://app.smartsheet.com/b/publish?EQBCT=1d447b4d658d488bacd135960036171e in this example, i have a customer who has asked to see four flavour varients of the same type of product, from which they will chose just one that will launch in their store. The volume forecast for…
Feature Request: Next/previous picture
I like that we can attach photos to Smartsheet, but it's not very convenient to go through them online. If I want to view the next photo, I have to close the current one and then open the next one. It sure would be nice if we could just flip through them without having to open/close for every photo.
Spreadsheet data source
I have a spreadsheet that automatically pulls in data on projects that my global team is handling. I have not been able to figure out if I can link this spreadsheet to SmartSheet. The reason I would like to do this is that this spreadsheet automatically pulls in new project requests down from SharePoint. Please let me know…
Purchase Order Forms
I want to create a purchase order form that I can send to suppliers by email from SmartSheets and receive a confirmation form back by email that the order is accepted with delivery details. The purchase order will need an internal authorisation. A unique PO number. Entry into the Smart sheet on authorisation. Ideally the…