-
% Complete based on Todays date, Start and End dates
I'm looking to return a % complete based on the start and end dates and the current date. So if a task starts on the 17/7 and ends on the 31/7, and today is the 24/7 - the % complete would be 53%. - (I want to have this as a separate column so I can keep dependencies on the actual % complete column) =(MIN(TODAY(),*finish…
-
How can I set a dynamic filter on a report to auto change to today's date?
I have created a report to track upcoming go-lives to display on a dashboard, I currently have a filter that specifies an exact date, but is it possible to have a filter that pulls in data for a date 30 days before todays date or even today's date? For example, a condition that will say Original Go-Live is greater than…
-
How do I add another IF statement to a Workdays calculation?
I am using the following formula (from a template) top calculate Working Days Remaining for a task - =IF(ISERROR(NETWORKDAYS(TODAY(), [End Date]@row)), "", NETWORKDAYS(TODAY(), [End Date]@row)) However, I want to add a condition to this that if the Status column for that same row is marked complete, then the Working Days…
-
Formula to show Current Status of Project Approval
Not sure if this would be accomplished easier with a Formula or with a Update Cell Workflow. We have a Projects Smartsheet that have 4 different Reviewers that need to approve. I'm looking to add another column for Reporting purposes that will show what approval step each project is on. For example, based off my attached…
-
Is there a formula or function that allows text to be removed and replaced elsewhere on the Sheet?
Hard to explain just in the question box. We have a staffing schedule for our company which allows us to see who is currently on jobs and who is coming up for availability for an upcoming job. We are trying to figure out if there is a type of formula or function that would allow us to type an employees name in next to the…
-
How to share a project sheet with some columns excluded
I want to share a project plan that is in a project sheet with my customer (viewing rights only), but I want to exclude some columns (internal budget related columns). The project plans are quite extensive and have multiple parent/child levels. So I want to keep the collapse/expand functionality for this. I have not been…
-
conditional formatting not working
I'm trying to make my conditional formatting work so that a column is highlighted a specific color is the % Completed column is over a certain amount and the Due Date is in the next 7 days. I even moved this rule close to the top of the list, just to make sure this would work. Can anyone help me fix this?
-
One Project - Multiple Clients
I have one project where certain tasks are paid by one client and the remaining paid by a another. Example: Data collection paid by Client A, Data Cleaning paid by Client B How would I set this up so when the smartsheet project is linked to resource managment the allocations are assigned to the correct client /budgets?
-
Import Outlook Calendar into Smartsheet
I was wondering if this is possible yet, or if there have been any updates? https://community.smartsheet.com/discussion/how-import-outlook-calendar-smartsheet Importing from Smartsheet into Outlook is nice, but I would love to have a 2-way possibility. I have a lot of projects going on all at once, trying to keep up with…
