-
Create a live copy of my sheet
I would like to be able to re-order my sheet without the parenting hierarchy in place. I was thinking that if I create a live copy that is always up to date but does not have the parenting information this would be easy. Basically, I have task assignments under projects. and different people are assigned to different tasks…
-
Resource utilization across projects
Is there a way to see the TASKS a resource is assigned to, across projects? The Resource View only shows which projects and overall Allocation %, I want to see the specific tasks. Thanks!
-
modify titles in calendar view
I really like the Card view and how you can show different fields or parents of things in the description. I would very much like this to be added to the calendar view. Defaulting to the primary column is very frustrating IMO and makes the calendar functionality almost useless for project management IMHO.
-
All my text, most of my predecessors and all my resource allocations - disappeared
I have been working on a Smartsheet for my client - I am a licensed user on their system. I had just tidied up all my reports and old sheets…. and disaster! I can see the structure of my plan, but it has lost all the text, predecessors and resource allocations! This is most strange - see attached screenshot. I cannot…
-
Add workdays to date
There are some columns that will be used to manage my project, "% completion", "Start Date","End Date", "Duration","Today". Now, our tasks show their completion percentage and I can see in the Gantt Chart how far the tasks run in the entire time and some of tasks seems like a bit delay from today. Therefore, I want to set…
-
BOX/Smartsheet Best Practice
Does anyone use BOX with Smartsheet?
-
Using a formula to subtract 1 box out of "box inventory" when I record a sale in "Sales"
Hello, We have a basic retail business selling iPhones and what I would like to do is create some type of formula so when I enter a sale into my Sales Sheet it will link to my Box Inventory Sheet AND it will subtract the correct box out of the inventory based off of its Model and Color. I'm not any good with creating…
-
Smartsheet unresponsive
I logged into my account and all my data is there but the page is unresponsive, I can't even select a cell.
-
formula or workaround...
Hello, I'm trying to build a sheet to use for our onboarding process. It would be nice to have on sheet for all positions. The issue is that all positions do not require the same onboarding activities. I would like to reference the job title / column and have conditions that would have the sheet only display or include the…
-
Primary column not sorting properly
My primary column contains numbers (1 to 250 and growing). When I sort I get the 200's first going up then the 100's. They are numbers as near as I can tell and not text. If I use the add/remove decimal places tool they respond properly? What am I overlooking?