-
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.
-
How to use SQRT function?
Hi! I searched through the functions and see that there's no SQRT function in smart sheets and the cells don't allow you to use the ^ key. Has anyone had experience, or have any advice on what to do? I tried making a whole new column just to root the function and it returns #unparseable, along with this the (A1)^0.5…
-
DropDown list - from another Sheet
hello , i have a huge list to be added in Dropdown, Does Smartsheet have option to pull the Dropdown from another sheet, (similar to excel spreadsheet).? Since the list will be Dynamic, editing the downdrop list everytime is time consuming. thanks Vasanth
-
Lock or Store Date/Value Solution without using Zapier
Hi all, I hope you're well and safe! I've developed a solution that lets you store the date or value. You'd use the copy-row automation and a VLOOKUP or combination of INDEX/MATCH to make it work. We'd trigger the copy-row to another sheet and get the created date/other value and then use the VLOOKUP/INDEX/MATCH to get it…
-
Function help
Hello, I'm trying to add a function so when I put the date of birth it calculates the age. Why isn't this working