-
Template of % of Job Duties assigned, not based on "completed".
Is there a template I can enter staff's job duties to calculate the % of time? Example: Parent would be Office with child of "accounts payable", "mail", "conferences". I would like to enter the % of each child and then have parent be 100%. There would not be a "Completed" % column nor start/end date columns. Thanks.
-
Multiple projects on one sheet
We have several large projects that require their own sheets. However, we also have many small projects that do not justify creating separate sheets. They are quick one or two day jobs, but they affect scheduling and P&L need to be factored into that. Does anyone out there use one sheet for multiple small projects? And if…
-
Percentage allocation of resources in a single row
Hi, If there are 3 people involved in a single task, and I would like to put 12% in person A, B, and C - is there a way to put all this information in a single row in Smartsheet, or does each person need a separate row? Thanks
-
multiple fomulas in one cell
Hello i'm new to the smartsheet community and wondered if anyone can help..... In one cell i need to use 2 '=RIGHT' functions and sum the answers together. is this possible? an example of the text in a cell is "tuna sandwich - £1.50". the '=RIGHT function needs to return 1.50 and the same from another column then add them…
-
Access list more than once
I'm in the home building business after I walk a house I make punch list for multiple subs to complete items that pertain to their trade. I have been sending "Send Update Request" to each sub. Some subs might have 10+ items.....they can't remember every item on the first time opened and would like to be able to refer back…
-
Cell Linking & Count Down
Hi everyone, I am pretty new to Smartsheet. I need to create a 'central' sheet that contains a product number and the quantity needed, then this information will link to a number of different company sheets. When a company orders that product number they will fill in the quantity the ordered. I need that somehow lock up…
-
Parent Rows not Updating from Child Last Modified
Hello! I have a column to track the time a row was last modified. This works great for my childrows, but my parent rows don't reflect the modification date of the child rows. Is there a way to have them pull from the child rows rather than its row (which will never change)??? Thanks, Claire
-
Sights - Widget Drawing Order
When you open a Sight, the widgets are drawn/updated in the order in which they were created/added to the Sight. For larger Sights where widgets were added later to the top of the Sight, the "older" widgets at the bottom are drawn/updated first. Is it possible in a future update to change this so that the widgets are…
-
Update Request with "add/subtract" formula to an existing number in a row?
A bit new to SS, so this may have an obvious answer, but I'm trying to set up a sheet to track inventory of, say, a dozen products. The initial setup is obviously simple, but then I want to choose the product rows that contain inventory quantities, and set up an automated Update Request to my delivery driver via email each…
-
Australian Users - Can you use Outlook App?
Hi there everyone, I am based in Sydney, Australia. Is anyone else in AUstrali aable to successfully download and use the Outlook App for Smartsheets, we have tried everything we can think of to allow the install, open and download the app and use it but NOTHING is working. Appreciate any feedback.
