-
Start Date & End Date in Minutes, Hours, and Weeks
Many thanks for the "Duration in Minutes" update. I also wonder if there is a way to enter Start Dates and End Dates in Minutes, Hours, and Weeks; too. For example; I have a task which starts at the 3rd hour of a workday and no predecessor task to it; but another task before it which ends at the 3rd hour.
-
Prorate function and duration
Something seems to have happened with the prorate function in the new release, or perhaps it was always like this and I just never noticed (in which case I apologise). I use the prorate function to provide linear projections of task completion. In other words I calculate what the completion percentage of a task should be…
-
PLANNED VERSUS ACTUAL PROGRESS
hi, is there a way that i can see the planned versus actual progress of the project ? baseline versus actual? thanks.
-
Release Notes for July 11th Upgrade
Hi Smartsheeters - In case you didn't see the link to the release notes @ the tail end of the blog post announcing the latest feature release, you can find the comprehensive list here: https://www.smartsheet.com/release-notes Going forward, we will be publishing detailed notes with each major release (as opposed to just…
-
Change the value of a cell from the formula results of another cell
I have a RYGG, Status and % Complete columns. The RYGG has a nested IF statement that takes its values from the Status cell. I manually enter data in the Status (In Progress, At Risk, ..., Complete) and the % Complete column (10%, 25%, 37%, etc.) I would like to know if there is a way that if I enter 100% in the % Complete…
-
Transferring Smartsheet from one account to another
Would like to know if I can transfer primary ownership and control of a specific Smartsheet from my account to another. Thanks in advance for any help you can provide? David
-
Saving eMail History
Only solution found: - cc myself on all email requests; this does not create/manage history well - create email as a discussion; save, then send that discussion Is it possible to save email's sent via smartsheets as part of the discussion for that line item?
-
'If' Formula that Pulls Data from One Cell in Different Sheet
Hi, I have a sheet that shows some data which I want to compile into a new sheet. The source sheet has a coloured (fill) cell and also a note. The formula would be in the new sheet, I want the 'If' to be cell colour or certain text / value (if I must) , the resulting value will be a percent. Has anyone made a reference…
-
Create time card from project schedules
Is there a template out ther somewhere to take all projects shared to an individual and create a weekly report (timecard) showing the number of hours that indiviual is scheduled to work on each project? It seems like most of this is available in Resource manager but I'd like to have it report hours versus % allocation.
-
Importing contacts from outlook
Hi, I'm having trouble important contacts from outlook. I have a csv (windows) file saved, but when i import it through smart sheet it tells me there are no outlook (csv) contacts found. I've opened the file. There are contacts listed in there. However, not sure if this is the reason, but the first name, last name and…