-
If Comment is not blank, then show the recent comment and date
Hi everyone, I have a Follow Up Date column and a Comments column. I have predetermined dates under the Follow Up column. I would like a formula to populate the most recent Follow Up Date and the corresponding Comments on the parent rows only if the Comments are not blank. Any help is appreciated! Thank you!
-
Reference cell in column on one sheet, against column on another.
I am trying to create a formula thagt will look at the "Item Name" columns numbers, and then check to see if any instance of that number appears in a column on another sheet, and if it does return "True", and if it doesnt return "False" I've had a similar equation in excel "=NOT(ISERROR(MATCH(A2615,'Up-To-DateLK'!A:A,0)))"…
-
Schedule Health based on End Date, Target End date and Todays date.
Need a formula for schedule health based on these conditions Schedule Health- Red: When end date is greater than target end date and in case end date is blank, it should turn red if todays date is greater than target end date Schedule Health - Yellow : In case end date is left blank and target end date is in next 4 days…
-
How to write a formula with multiple conditions?
Hi, I have these 5 Phase columns in my project tracking sheet. Now i want to automate the column named "Test" that shows at what phase the project is currently in. The logic is something like: "If the Phase 1 is 100%, Phase 2 is 45%, Phase 3 is 65% then the project should be at Phase 2" Ideally if the phase is at 100%, It…
-
Milestone Duration Not Calculating Correctly
When putting milestones into a project plan, the duration is calculating as "1d" instead of "0" like it should. I cannot figure out why this is happening. Can anyone please advise?
-
Can I automatically adjust predecessor dates by changing the dependent date?
I'm looking to create a dynamic project schedule with the functionality described below and would appreciate any help from the Community! Our dependent task end date changes rather frequently based on shifting priorities. I would like to change the final dependent end date (in this example, 'swim') to 3 days later (9/10)…
-
Linking an Excel cell to Smartsheet a cell
Dears, I would like to collect status updates from test scripts created and used in Excel and present it in Smartsheet. All test scripts in Excel have one cell indicating the percentage completion level of the test script. Objective is to link that one cell to Smartsheet sheet where I present the list of all test scripts…
-
Card View: Limitations on how much text can be displayed on one line, etc.
I have noticed there are some confusing limitations imposed on the desktop version of smartsheet that are not on the mobile. I have one primary concern to focus on: When I am on desktop, card view does not display any more than one line of text before adding an ellipsis (...). Why is it limited like this on desktop but not…
-
Find next milestone in project plan
I have a project plan in which I want to write a formula to retrieve the next milestone, a task with a duration of zero, from a list of tasks. Task Name = Text/Number column Duration = Duration type column Start = Date column I have this formula which returns the first milestone in the Task Name list. The first task with a…
-
Hierarchy Drill Through Solutions?
I feed my sheets into Power BI (pre-formatted gantts) and I need to create a way to drill down through levels of a sheet's hierarchy. Ideally, at least 4 levels of the hierarchy, Great Grand Parent, Grand Parent, Parent, Child, if you will. I'd like to mimic the concept that's in MS Project, on the View tab, Data group,…