-
Identifying Current working Task and it's Parent
Good day! I've been reviewing quite a number of ways in finding the current task, last completed cell in a column, etc etc and cannot get what I need to work. I've attached screenshot with the data in my sheet and I'll provide the formulas below. What I'm after is looking for the last non-blank cell in the Status column,…
-
Column Filter
Hi all I am not sure if I am missing something with the way filters work in Smartsheet but is it right that I cannot add a filter to each column which automatically updates the list of inputs from the data in the cells below it? Basically I want what Excel does when you highlight the titles of a column and hit the filter…
-
Report connecting multiple sheets
I would like to create a single report pulling data from multiple sheets based on primary column, start end date, Assigned to and status. How could I achieve that? Currently even if I add multiple sheet to report criteria it pulls data only form 1 sheet.
-
How can I use a calculated duration that uses my own formula?
I want to use my own formula to calculate duration. I've added a Calculated Duration column, but I can't select that column in my project settings. What governs what column you can select for your duration column?
-
How do I automate the creation of a project schedule from a form submission?
Hoping someone might be able to help me figure out this workflow: Form is submitted requesting a new project with the following information: name of project, requested go live date, assigned project manager This form submission triggers a workflow that will automatically pull a project template, inserts "name of project"…
-
Automatic project creation and reporting
Dear community, I have a scenario which gives me quite a headache. I would like to create a form which will be populated by the project requesters for creating projects in Smartsheet based on a set template. The form will have multiple fields. Once the form is submitted it will have to trigger an alert/reminder for…
-
PMO Template
I am struggling with the PMO template and the Schedule Health column in the Project Plan, which is indicating 'Red' even after a Task is complete, with this formula. =IF([Schedule Delta (%)]@row > 0.1, "Red", IF([Schedule Delta (%)]@row > 0, "Yellow", "Green")) Could I use a formula to ask it only to count if "Status" is…
-
Need help calculating the percentage of all project tasks and return a value in percentage
Hi, I am trying to add a project status percentage in my project dashboard. I have the list of tasks, % complete, and Task Status in the project sheet. I tried to use the sheet summary to get the % value of the tasks that are not marked "completed" but I am not able to. What is the correct formula to use in the sheet…
-
Conditional Formatting in a Report
Is it possible to include Conditional Formatting in a Report? I see discussion on this topic from a few years back, wondering if there has been an update or an easy work-around to include Conditional Formatting in Reports. Thanks!
-
Struggling with an IF/OR/AND formula
Hi, I have a formula I'm struggling to put into a single IF/OR/AND formula! Basically, if the [Add-ons] column includes the tag "Prebill" AND if the [Final Invoicing] column is “Invoiced”, I want the [Total Amount Invoiced] column to add [Prebill Actual Invoiced] and [Final Invoicing Amount]. To clarify, if just one of…