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
Merging all sheets
HI, Is there any possibility to merge all sheets altogether? For example - I have 3 sheets name January 17, February 17 & March 17. Headings are the same but data is different. How can we merge all three sheets while exporting it into MS excel? Regards,
Advanced Notifications: Stay on Top of Important Changes
I have been waiting for these more advanced notifications for a while now. Thanks for getting this to a much happier place. I tried creating a generalized "team" notification when any given shared user is assigned a task, I would like them to receive the notificaiton. From what it looks like currently, this is possible,…
Sum children networkdays
I am working on a complex formula that I won't get into the details of but I am having a problem with one small part of it. I need to check the children of a parent row to see if the task has already started but not ended. Column names are {Actaul Start] and [Actual Finish]. Then if this criteria is met I want to get the…
COUNTIFS with a date range and symbols
This is probably a no brainer for some of you with a lot more experience so I apologize ahead of time. For argument's sake, I have 2 columns. Column 1 we'll call DATE, column 2 we'll call SYMBOL. I'm looking to count the number of "GREEN" symbols that have a date greater than or equal to 1/1/2017. When I use the following…
Conditional Notification - Feature Request
I absoultely love the updated notification system, but would like to see a small tweak. I have a sheet that has a contact column. I want to notify the user whenever something changes on a row that is assigned to them. I can do this by creating a notification for each user, but there isn't a way to do this automatically.…
Web forms
Hi, i want to create a more complex web forms. did you have integration with any other web form app?
Status Changes
Hello, Is there a way to run a report that will tell me all of the changes that have made in my sheets? I know I can go in individually and do that highlight changes command, but I have so many sheets it is impractical. I would prefer to accomplish this in a report that pulls in the data from all of my sheets. - Adam
Fill a client order
Good morning, can anybody share a sheet or idea to register the sale order. I am novel in smart sheet and now I solve using a list to slect or chose a data of the client, and then register it like, name. adress, state, etc, but it takes some time and space. Thank you
Update request email
Is there a way to send an update request for multiple rows just to include the open update form in the email and not list all the rows that are being requested to update?
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…
