Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums. Archived 2017 Posts
Archives for April 2017
Discussion List
And ... what about copy/pasting attachment ?
Saving attachment from mails to attach them to an action or whatever in a sheet is boring. What about alowing Ctrl C / Ctrl V instead of upload? THANKS! Cheers, Bruno
% Complete versus % Planned
Hi! I am trying to have two columns in my sheet: The original "% Complete" one and a "% Planned" one. It will help me check if my projects health is ok, by meaning if its percentage is above, equal or under the percentage of the project that was estimated for that date. I tried inserting a regular text/number column with %…
Indivisual Row Sharing with Different Users is it Possible...?
Can we share indivisual rows with different users to update sheets. we dont want to use any web forms we need to share sheet, but different rows to different users.
Emailing Sheets with attachments
I have a sheet that has attachments to every line. I need to email this sheet, with the attachments to several people. When I use the email function (send of share sheet) only the spreadsheet comes through, but none of the attachments. Is there a way to do this???
Create formula across multiple sheets
Is it possible to create a formula that pulls data from more than one sheet, or are formula only able to work in a single sheet . Thanks Hugh
Can you set a task to ignore non-working days?
Can you set a task to run for a fixed number of days - regardless of non-working time? For example - I have a 3 day task which is the time it takes for changes to be applied to a User Account (e.g. the addition of new software, changes to security permissions, etc). This takes 3 days. Weekends and Easter Holidays don't…
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…
Getting the Top 10 Largest Values
Hello! I was wondering if there is a formula where I can generate a top largest values based on my data. Like for example, I want to get the top 10 largest Man Hour with their Employee Names listed. Looking forward to your responses. Thanks
Mid and Value formula
Calculating cost of multiple projects in one sheet
I would like to calculate the cost and hours of multiple projects in one sheet, I would like to see how the cost and the hours of the project are increasing and decreasing in the various phases of the projects. I would also like to put this information on my dashboard and report it to leadership as a visual report.
