-
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…
-
Automation Not Running as Scheduled, Nor Consistently, But Sometimes at Random?
I have 22 projects with identical tracking sheets and identical automation set up on those tracking sheets. The automation has been set to run every Friday for the last month. It just copies the current rows to another sheet, that other sheet becoming a "ledger". I have one column that says "todays date" so when I go to…
-
COUNTIFS and SUMIFS formulas with multiple criteria AND a dynamic date range in a sheet summary
Hi everyone, I've had a look in the forum threads to try and find an answer already, but not sure what I'm trying to do is like-for-like with some of the suggestions. BACKGROUND: I'm helping colleagues with aggregating some of the data in their deployments sheet, which they use for managing and tracking their events, the…
-
Parent row status formula based on child rows
Roll up formula for status I have this formula (shown below) where I am trying to get the status of the parent row automatically entered based on the child row. I'm not sure if I've stared at this too long and my eyes are crossing, but it's not doing what I want it to do. I think I've listed all the permutations below. 1.…
-
Merged: Everybody should be able to see a Gantt view in Todays Date
This discussion has been merged.
-
Extract text from one cell to populate the assignee cell in a Smartsheet recognizable contact?
I have a challenge i have been racking my brain on for a while. I want to extract names from my ACTION ITEM cell that will update the ASSIGNMENT correctly instead of just a text string. I am using the =MID, FIND ":", LENS, FIND ":" to extract & populate the HELPER COLUMN, but then want to make sure that the ASSIGNEE will…
-
How to write VLOOKUP to source data from multiple sheets
I have a Master Project sheet and multiple individual project sheets. I need to gather one piece of data from the individual project sheets to write into the row on the Master Sheet. While VLOOKUP will work, the wizard requires me to know the sheet that I want to search. I need to reference all sheets in a workspace as the…
-
Move all tasks to new column, not just Parent cards!
I primarily work in card view, running the project via Scrum methodology. When I move level 1 cards into the 'done' column, it doesnt move the level 2 subtasks into 'done' as well. This is an expected outcome for Smartsheets, but I'd argue that when working in card view, you would only move parent card into 'done' when all…
-
Inactivate a task
Is there a way to make a task or group of tasks inactive in a project plan? In Microsoft Project there's a function called Inactivate that's used after you select tasks that you want to make inactive. Doing this does not affect resource availability, the project schedule, or how other tasks are scheduled. I know this…