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
Linking Sheets
I am trying to link two sheets. The main sheet contains all my essential information, however one column has a list of drop down options. If the user selects a certain option from the drop down I want certain information to be presented in a separate sheet. E.g: If in sheet 1, monthly payments are selected from the dropβ¦
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Β