Connect with peers, share your expertise, and inspire what’s next in Smartsheet — from proven practices to practical how-to insights from fellow users and product experts.
Sign in to join the conversation:
How can I stop Smartsheets.com from sorting my online spreadsheet alphabetically by the first column?I have pasted this spreadsheet directly from Excel 2016 and I want it to stay sorted in the original order; I don't want the spreadsheet to be sorted by alphabetically by the first column within Smartsheets.com.How can I prevent Smartsheets.com from sorting my online spreadsheet alphabetically (so it will retain its original sorting)?
If you want to stop Smartsheet sorting automatically without having to reapply filters/sorts, first hide the Primary Column (the one in bold) and then paste your data in from Column 1 onward (or whatever your remaining columns are named).
I have build a email validation in my sheet where entered emails from a form are entered in a contact field. another field verify the address and validades using the following formula: =IF(FIND("@xxxxxxx.com", [Student eMail]@row) = 0, 0, 1) if the checkbox is triggered (=0), then the registration is valid, and the the…
I have a sheet that has a good number of automations that populate a field based on a value changing in a cell. These same automations have been working just fine since March up until today. All of a sudden they are being triggered when there is no change to the cells in question. If I click into the cell history, it…
Hi, I'm in the midst of a Smartsheet trial and would like to understand how to set up a project schedule that uses a firm delivery deadline. I understand I could use Start-to-Finish relationships, but this disallows use of many to one predecessor relationships (multiple tasks that are gated by a single work item). I would…
