-
Give Option to Open Side Panel
My team noticed in a recent update that a side panel automatically opens up any time a smartsheet item is opened from a shared workspace. Can we have the option to turn this feature off so that we don't have to click the "x" every time to get rid of it? I've attached a photo of the side panel that I'm referring to.
-
Verify if there is comments in a row
Good afternoon, Is there any way to automaticaly know if a row has any comment or document ? My goal is to have a cell that return true or false if the row contains a comment or a document in order to add condition on my sheet. So is it posible to call the cell that contain conversations and comments to check if it is…
-
Creating Expiration dates based on products
I want to create a formula that will auto-generate expiration dates for individual products for an entire column. The sheet has a created date and column containing a dropdown list of products. The products have different expiration dates. Ideally I would like to format the expiration date column to have the product…
-
Collaborative and real-time editing
If multiple users end up editing the same cell without realizing, the last change that was saved overwrites the other. All editors should be able to view the current cell that is being edited and should be able to lock them as they continue to edit.
-
Can I turn comma separated lists into multiple-choice dropdowns?
The title basically says it all. I have a column that was built in Excel, with multiple items separated by commas (no spaces) to make a string of about 1-5 items. We're moving our processes into Smartsheet, and I want this information to be formatted as a dropdown column with each item chosen as a separate entry.…
-
"Live" source template sheet
We have projects running with long and complex workflows and thousands of tasks - so we need to break these down into multiple sheets (dozens), and then use reports to extract data from tasklits to time-tracking and budget burndown. However - if we need to change the structure or components of the sheet in any way ( extra…
-
Report on Last Comment date?
I'm seeing that the System Modified field is NOT updated after entering a new comment on a row. Is there a way to report on the Last Comment Date? I am trying to identify a way to create a report on my sheet that shows Last Update dates, and Comments are being utilized to provide a status update, or entry of the last…
-
Dynamic Drop Down in Forms
Hi, I've tried googling and searching the forum but cannot find an answer for my use case. As part of a 2 stage project approval process I want to create a form that has a dropdown option to select project ID numbers from a list of projects that have passed the first stage. e.g. If I have 3 projects PROJ01, PROJ02, PROJ03…
-
Importing Excel Spreadsheets into Smartsheet
I am trying to automate a function that we desperately need. We have a spreadsheet that is generated every morning and every night. I want to import it into a Smartsheet that I will use for a Dashboard. My problem is that every time I import the spreadsheet it creates a new Smartsheet and I lose my Summary fields. I need…
-
Close Web Browser after Redirect into App
This is when you have the Smartsheet Application installed along with the browser extension. Once it has redirected successfully close that browser tab so the user can resume without any extra input.
