-
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…
-
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…
-
Nest IF limit or error in statement
Hi Folks - I'm trying to write a long formula that evaluates nearly 40 criteria then based on that criteria assigns a score. Is there a limit on the number of IF statements and if so what is it? If there isn't, then what am I doing wrong here? OR is there a better way to do this? The error I get is #INVALID OPERATION (no…
-
How to get notifications when a new entry is added via a web form
I have a web form which users use to create a new line item that requires approval once added. An automatic notification must go out to the person that needs to approve. Thereafter a notification must go out to another user to inform them of the approval. How do I set up the notifications when a new line item is added via…
-
Conditional Formatting: "Today is in-between Start Date and End Date"?
Hi all, I built a filter to show my tasks that are due today with a green highlight. However, it does not capture tasks that last across several days (see the different shades of green in the attached image - bright green is a "today" task, and the woodland green is default). How can I extend my conditional formatting to…
-
Resource Loading across projects
Hi, I have a situation wherein a developer is working across 3 projects, with his loading being: 1. Project1 - 50% 2. Project2 - 25% 3. Project3 - 25% When i plan his task for Project1, i need to ensure that he is only 50% and accordingly the duration for the task needs to be calculated. Is there any method where i can…
-
Add Card appears in Row 1039 - each and every time - any idea how to fix the bug - thanks
Add card appears in Row 1039 in Grid View - I only have 55 Rows occupied with fields - i've deleted , refreshed, but makes no difference. Each time Add Card appears in Row 1039 - any idea how to fix the bug - many thanks
-
Dependent Drop Down Lists
I need to create dependent drop down lists. We are dealing with multiple categories that then have many subcategories each. In Excel I can create a dependent drop down where if the value of cell B3 is Accessories, then the only choices I have in cell C3 are the accessories subcats. Obviously one can manually choose the…
-
All videos simple - don't show realty use of training needs
Anyone noticed that all trainging videos are so simple of solutions they really don't help with much beyond the most basic. Like conditional formatting - show me how to deal with wanting multiple columns to change format based on one criteria - not a whole row. How do you do that? How many formats do you really need to…