-
Function "Current User"
Of course, the information about the current user is already available in the system, after all we can access it via filter. But I miss a function that would allow identifying "Currentuser()" via formula. I'm making individual dashboards and would like to generate personalized statistics for each user, which are…
-
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…
-
Cascading Forms
Cascading Form data sets is one of Smartsheet's missing capabilities that I believe would be a game-changer for many alternative providers. Cascading forms are a very effective technique that can be used to compress form data and limit down options in order to narrow a workflow or collect more accurate data. Recent usage…
-
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
-
Lock the columns for everyone other than Smartsheet admins.
I want to lock the smartsheet columns for everyone to avoid the shuffling the column every now and then. And users who have access to the sheet, they can only edit the details but should not be able to shuffle the columns. Is it possible to achieve?
-
#NO MATCH result with INDEX/MATCH formula referencing Auto-Number/System
I use the INDEX/MATCH formula across many of my sheets for many years. This is the first year I've encountered this issue: my formula is indexing information referencing an auto-number system column type. We generate 3-digit "reference IDs" in this auto-number column to make it easy to index information for that respective…
