-
Auto-Copy Formulas
I was having some problems with standard =this+that*something formula not copying down when I add a row. When I add an IF() statement to the formula, it seems to work. I noticed this, because all of the IF statements in other columns were working, so I thought I'd test the theory (add the IF()), and it worked. Anyone else…
-
Multiple selections
Is there a way to create a multiple selection option in a column? Was considering Checkboxes that could be linked to the selection by typing next to it or drop down options with ability to select multiple choices? Please let me know if anyone has created something like this or if there is an option to do something like…
-
Automated send format question
Good morning, I'm setting up an automated weekly send for a report. I need send it in the vertical format, as though you are sending a row. As it is, it sends in a PDF which is a linear format, and not user friendly for our purposes. Is it either a: Possible to send a vertical format on an automated/recurring basis or b:…
-
Sorting between SmartSheets
I am fairly new with Smartsheet but wish to create 62 separate sheets that will track various organizational activities. My question is this. Let's say that 15 teams (each tracking their activities on a separate smartsheet) all take the same training. Is there a way for me to do a sort so that a list of these 15 teams will…
-
Formula to move a row to another sheet?
Good morning, I'm hoping I can formulate a column so that if the checkbox is checked, it will move that row to another specified sheet. Can this be done? If column A is checked, move to Sheet B is the basics, but formulas always mess with me. Blessings, Loann
-
Smartsheet Merge issue when using Combine-into-one-file option
When I attempt to use the combine into one file option, such as when I'm using a 1-page Google document template to print five (5) rows into 5 pages, the combined file output exhibits the following errors: 1. Contents in the header are not displayed in the combined file per page; when I use the merge print on single pages,…
-
Advanced Notifications
Still loving this new feature but I am finding a couple of anomolies and I am unsure if it is something I am doing wrong. The email notification tells me that changes are highlighted in yellow, yet some are and some are not. Can anyone offer any advice? Many thanks Natalie Gorman
-
Workspace Logo
Can anyone tell me if there is a limit to how many logos you can import? I am trying to add a logo to a workspace, which I have done successfully on previous occassions. I am currently using 3 different logos but need to add a further one, however I am getting an error message suggesting that the format of my logo is not…
-
NOTIFICATIONS - THANK YOU, THANK YOU!!!
I am beyond thankful for the major improvements to the Notifications area in Smartsheet. I love every aspect, and our team is very pleased. Can't wait for the reminders improvements - that will be an even bigger benefit for us!!! Blessings, Loann
-
Constructing User-proof formula
Any ideas on constructing more user-proof formulae? I'm having trouble with users inserting rows in a sheet versus appending new rows at the bottom. Locking rows doesn't prevent an insert (would be nice if a non-admin user couldn't insert when adjacent rows are locked). I've used the following formula to ensure the first…
