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. Archived 2017 Posts
Archives for August 2017
Discussion List
Define a named cell
I could not find the equivalent to a define named cell in smartsheet, the closest I find is refer in my formula as $[column]$row and that is clumsy when i want to xxx * $[column]$row. When in MS Excel i can just xxx * rates where rates is $[column]$row Did i miss it in my search for smartsheet help?
Smartsheet Sorting
Hi, Is it possible to sort data without having it sort the first two rows of data because the first two rows of data are my column titles. My column titles are just repeats of the smartsheet column titles. Thanks! Kevin Au
Round to nearest 0.5
Hello, We are building a time management sheet based upon a simple Smartsheet feeding information from a Form. After we've received the information we want to round the calculated results to the nearest 0.5 (see screen capture) The data we receive are collected and calculated in plain text/number columns. The Round formula…
Future Date Calculation
Hello, I am trying to find a formula that will calculate out 90 days from a given date AND give the result as the last day of the month. The given date is Completion Date Estimate i.e. 10/31/2017 of a project and I would like a cost cut off date that is 90 days later on the last day of the month i.e. 01/31/2018. One…
Formatting lost when pasting to Word
When copying and pasting cells from SS to a Word doc, all formatting is lost including any highlighting, font changes, etc. Only the text can be copied and pasted over to Word.
Hyperion Link
Hello - Is there a way to link Hyperion directly into SmartSheet? New user and trying to determine the capabilities. Thanks!
OCR FOR THE MOBILE APP
We would like to use the mobile app for expense reports. We would like to be able to take a picture of receipts and have the app recognize the data and auto fill forms (OCR). Is that possible using the Smartsheet app?
Add up prices in a column if checkbox is selected.
I have a list of parts and prices. I would like to have a total cost add up for the rows selected by a checkmark. Basically it is a parts list and I am trying to add up for a quick quote the items selected. Is there a way to do this?
Notify an assignee that the predecessor required to start work has been completed.
I am looking for a solution that will allow an email to be sent to an assignee informing them that their part of a project can begin since a predecessor was completed. Any help would be greatly appreciated.
Formating in Smartsheet
Cell merge function I have seen that this function is still not in place. Can anyone tell me when this function will be implemented? Or is there a way, where I can use a text in one my Project templates with an instruction text to guide someone through within my template, for example my due diligence questionnaire (DDQ),…