-
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.…
-
Column headers not aligned
My column headers recently became misaligned. I have attached a screenshot. This is only happening on some of my sheets but not all. Any time that I create a new sheet this happens as well. I am working on a Mac and using Safari. Note: When I use Chrome on the same Mac, I do not experience this issue.
-
My - Smartsheet Wish List 4 - Capacity Estimate
This is similar to my last one but I put it seperatly as it is a much more complexed issue. A property column visable in the Home screen and in the Properties dialogue box tha gave a rough estimate of capasity in %. This would need to use an algorythem based on Rows*Columns as a 5 of Capasity weighted by Use of Hierarchy,…
-
My - Smartsheet Wish List 3 - Row Count and Column Count in Home view
It would be realy useful if two of the Info/property columns in the Home view were the Row count and the column count for quick reference and a guide to how big your sheet is getting. These properties should also be in the Properties dialog box accessed from the sheet menu. If you agree Like
