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
User dashboard metrics?
Is there a way to see the metrics of how often a Smartsheet user uses the app? I have the sysadmin user report where it shows last login, but that does not identify the heavy users.
Release 2016-08-06 unintended consequences (part 2)
I noticed that many of my sheets were "updated" on Aug 7th. Many more than is possible or likely. But not all. So something triggered the update. Perhaps associated with the new formulas. Normally, I likely woudn't even notice this, but I'm in the middle of working with two clients that have far too many sheets and they…
MATCH Formula
OK I'm loving these new formulas but I need help with the MATCH formula. I have column A with serial numbers in it. I want to scan serial numbers into column B and use the MATCH formula to match it to column A. How would you write the formula?
New Hierarchy Function - ANCESTORS()
http://help.smartsheet.com/articles/775363-using-formulas I got super excieted when I saw the new Hierarchy functions, ANCESTORS() & PARENT(). I get PARENT(), know where I plan to use it and am happy to have it. After testing out ANCESTORS() and reading the blog, I realize that it's primary intention is for forconditional…
Release 2016-08-06 Comments feature doc misleading
The new functionality doc: http://help.smartsheet.com/articles/521892-adding-discussions says this Other actions with comments require additional permissions: * To edit a comment, you must be the author of the comment. * To delete a comment, you must be the author of the comment. Neither of these appear to be true because…
Disable Rollover Formula Preview
Hello, Is there anyway to disable the feature that previews the formula when you roll over a selected cell? My sheets often have very long formulas in the Primary Column and the rollover gets in the way of being able to read the sheet effectively.
Sending a row-with hightlights?
Hello, When I send a row to someone in my contacts, I want the information that was been recently changed to be highlighted (to alert the person of the changed cells when the sheet is quite large). Is there a way to do this? I have the "Highlight Changes" on, but it does not show up in what is emailed. Thanks for any…
Internal links not working
I have an issue (that probably got addressed but I couldn't find that ). If I add a link to my sheet that points to a local document, I can't click on it. It would be all good if I could copy the link itself and use it in a file explorer but that doesnt even work. Any solution? Thanks! Étienne
Error while transfering a formula from Excel to Smartsheet
Hi! Someone tried to transfer a formula from excel to smartsheet... The only problem is that the formula is quite long and there is one/multiple error(s) left. Can someone help? I've found a few ones ( ; instead of , ... WEEKNUM instead of WEEKNUMBER) but I can't get it to work... Here it is. I colored the different if…
Email trigger help
I need to find a way to send an email with a smartsheet web form link that is triggerd by a date in another smartsheet. I have a smart sheet with a customer list and a date colum that indicates when they need to receive an email reminder. The dates are different for each customer. When that date is reached I need a trigger…
