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 November 2017
Discussion List
Feature suggestion
Is there a place to make feature requests? Does SmartSheet share their product roadmap? Here's one for the backlog: add an option to hide the dependency arrows on the Gantt chart w/o the need to disable dependencies. I would add this to a larger category of feature requests I would call "making Gantt charts more…
hide certain columns per user
Basically: I want to hide certain columns for specific users. In detail: I have 7 users shared to an affiliate sheet. This sheet contains the assets needed for marketing as well as rev share and money exchange. I want my graphic team to update the status of graphic assets but I don't want them to see the rev share columns.…
Formula to check if cell contains a value from a range of cells
For example, the text in column 4 row 2 is "xxxxx_email address=test@test.com" * The text in column 2 row 11 is "google@google.com" * The text in column 3 row 11 is "1" * The text in column 2 row 12 is "test@test.com" * The text in column 3 row 12 is "2" * The text in column 2 row 13 is "smartsheet@smartsheet.com" * The…
Converting Numeric Values to Days
Hi, I would like to input a quantity in a cell and use a formula to convert it into days of production. I have accomplished this with the exception of the Duration column does not convert the numerical value into days for the Gantt chart. Please help. Thank you, Dennis
Formula to check if cell contains text string + value in another cell
For example, the value in column 4 row 2 is "xxxxx_email address=test@test.com_xxxxx" The value in column 2 row 2 is "test@test.com" I need a formula that checks if column 4 row 2 contains "email address=test@test.com" by crosschecking the value in column 2 row 2 and using the text string "email address=" I have it worked…
Nested If/And Statement
I am trying to figure out a nested IF/AND statement that will alert me if an estimate is older than 90 days and a work order has not yet been started. I simply have a 'Needs Attention' column that will show a checkmark if this is the case and otherwise just displays an empty checkbox. My formula below works as it should if…
Is it possible to set due dates based on a formula?
Hello, I've imported an Excel sheet and my formulas aren't working. I'd like to automate due dates where the duration may change based on a numerical figure. For example, if there are 10 items to move, it will take 2 days for each of 4 tasks, but 100 items to move will take 5 days for each of 4 tasks. I've been playing…
Enhancement Request: Need Rule name for Reminders just like Notifications
When setting up a Notification Rule, there is a Rule Name field to aid in differentiation of the various rules. There is no such option for Reminders. If there are two or more Reminders they require more parsing to determine which one is which This request has also be posted to the Form Craig
Highlighting Gantt Chart Information
Hi, Is it possible to highlight multiple blocks on a gantt chart at the one time without having to CTRL+ each individual block? Thanks Emma
Creating a Sum for Filtered Rows
I have a Sheet which contains a complete list of all invoices, which Customer they are for, the Invoice Total and an Invoice Paid column which would show the balance of the Invoice. I have created a number of Filters for all of my Customers, so that I can filter straight to one Customer and see their outstanding balance.…