-
How do I remove the Share property to a Sheet that I've saved as a back up?
How can remove all references to a sheet? Here's a summary of what I've tried. * Sheet A is my Master on which I have many project tasks out to various resources. * I made a backup of Sheet A and called it Sheet B. * I then deleted a lot of tasks from Sheet A knowing that I had them saved in Sheet B. * I removed sharing on…
-
Managing large number of filters
I manage product releases and have multiple columns that I need to filter by (department and owner). I have a variety of entries in a given column, but I cannot find a way to click the dropdown at the top of the column and select one of the values within that column (like how filter works in Excel). Am I forced to create a…
-
Gantt Chart sum of days for subtasks
Hello everyone, We're using gantt charts to planify our tasks. When creating task groups and sub-tasks, the number of days displayed in the task group does not reflect the actual number of days planned but the time span from the beginning of the first task to the end of the last task. This creates confusion when presenting…
-
Formula trouble with IF or IFS
I have a sheet being used as a project schedule in which I want to auto-indicate the project lifecycle stage in a cell on the sheet's meta-data line. To do so, I envisioned using an IF AND statement or something similar. Below is a mock up of the way it might look in excel. Project Lifecycle Phase = XXXXXX COLUMN B C Row %…
-
Column misalignment
I have had this issue on and off for a few weeks. After using toolbar to make changes to sheet the columns dont line up with the header descriptions. Anyone else having the same issue? Regards Wayne
-
refresh
So I have what I hope is a common issue resulting in a simple solution - when I make a change on my mobile app, the desktop "main" sheet doesn't automatically update. The only way I can think of to work with this is to remember to refresh the main desktop sheet. That requires mousing over the side bar "sheet" icon and…
-
Project Resource View
Hi Friends, In 'project resource view' currently I can see all members (project assigned members). But I don't want visulaize all members capacity at once. Is there any filter option? Reason: One month back my team member moved to other team & I am not assigning any task, yet I see him/her in the 'project resource view'.
-
Currency converter
Hi, I have project expenses in different currencies (EUR, GBP, CHF, AUD) and need to convert them all in USD. Is there a solution how I could enter fix exchange rates and after entering e.g. EUR 100.- to get it automatically in new cell / row converted in USD 112.-? I have added the example
-
Leading zeroes won't populate
We have a sheet with a column for zip code and the type of column is Text/Number. However, if the zip code starts with a "0" it won't show the leading zero. Thus we end up with an incorrect zip code entered. I'm sure it's an easy fix, but I"m stumped. Blessings, Loann
-
numbers that start with zero and webforms
I have a webform that I am trying to create but one of the columns is a number field where the number commonly starts with a 0. My problem is that when you submit a number that starts with a 0, the 0 gets dropped unless the field is formatted as text. In smartsheet, the only way I see to format a field as text is to add an…
