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
30-Day Prompt
Hello, I'm needing to create a sheet where a task has a start date of say, 11/1/2017, and then I need to be reminded of something 30 days from the start date, 11/31/2017. Can someone help with the formula for that? (Column A would be "Task" and Column B would be "Start Date". I'd like Column C to be "Action Date." There's…
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…
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.…
Assigning a unique favicon / thumbnail
Is there a way to assign a unique favicon / thumbnail to a smartsheet forms URL? So that a smartsheet forms URL once added to a IOS or android device home screen can be something other than the smartsheet check mark. Thanks.
Progress Report Chart
Hi I have a table which indicates number of tasks of different sheets for each person under status Green Yellow for completed and pending tasks. I would like to have a graph on the progress of each person on over a period of time. At the moment, I have to copy paste at the end of each day, no of tasks competed versus…
Form Results Page
Can you view all form results in the same format as the form? In other words, seeing the form with answers provided (scrolling down through questions) rather than results being displayed across like a spreadsheet?
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…
SQL Server to Smartsheet
I want to fetch live data from SQL Server and make reports from it in Smartsheet. How can I do that. I have live data connector and Cdata. How can I export data from SQL Server to Smartsheet ?
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
Improved Way to Alphabetize a List Using SMALL()
I have a project dashboard that links in data from several other sheets to show an overview of project financials and time charges. In a couple of cases I needed to sort the results by project number which includes four numerical characters, occasionally followed by a single alphabetical character, none of which I could…
