-
Spreadsheet data source
I have a spreadsheet that automatically pulls in data on projects that my global team is handling. I have not been able to figure out if I can link this spreadsheet to SmartSheet. The reason I would like to do this is that this spreadsheet automatically pulls in new project requests down from SharePoint. Please let me know…
-
My - Smartsheet Wish List 5 - Recently used List
This is available in the Tablet/Phone app but not on the PC platform. Please can we have this included under Favorites.. If you agree Like it
-
My - Smartsheet Wish List 2 - Unhide Specific olumns
Currently you can hide columns individually. However you have to Unhide all of them. This is extremly frustrating when you only want to ammend one column. This also causes the issue in trying to remember which ones were hidden and for what reason so that you can rehide them again. If you agree Like it
-
Help: Using =IF and Replace
Hello All, I need help making a formula that will replace a cell with Static Information with a pre-assigned phrase when the information present in a row's range (IE [Room Assignment]22:[Room Assignment]50) matches cell's information. I'm lost on how to make this happen, and hope the solution is simple. I have a limited…
-
Color Formatting
I have been noticing that my color formating occationally changes. I have one sheet I am working on that I color cordinated parent and children rows. Frequetly while editing, expanding and collapsing row, some cells will revert to white. Is there a reson for this, something I am doing wrong? Or a way to prevent it?
-
Sorting Capabilities Changed?
Since the newly updated sheet, I can not for the life of me sort a column. I know I have to remove all filters but the option to sort is still greyed out. Please advise....
-
Love the "Freeze" pane option!
We just started using this option, as we have 71 columns in a particular sheet and scrolling back and forth was becoming quite cumbersome and inefficient. We put our three most important columns at the front of the sheet and the the freeze pane in place at the end of the third column. So far it's been noted as a very good…
-
Recurring sheet with sub-tasks all nested.
"sub-tasks" nested under multiple main tasks in a recurring sheet; is there any way to open all the sub-tasks at one time rather than selecting each "+" to open them?
-
Mail Merge Multiple Rows of Data
The task that I am trying to accomplish, is to complete a complicated mail merge for mass email. The mail merge function in MS Word or Google Docs sends out emails based on each row in your excel data sheet. Each row equals 1 email to 1 recipient. The issue is that multiple rows of data have to be sent to 1 recipient. If I…
-
Notifications to specific employees
I have 10 employees. I have a month-end assignment sheet where employees are assigned to tasks. I would like to send out an automatic notification to the assigned employee when the task has been approved by management. Alerts - Reminders have the feature of sending the reminder to the actual assigned person, not everyone.…
