-
Formula needed to show project week
Hi all, I'm trying to put a project week column in my timeline, and I need it to return the actual project week and not the calendar week when looking at the start to finish date. Example: If my project started on 31/10 this will be week 1. The formula looks at the task start and finish date and returns - 1,2,3. This is…
-
Roll-up multiple projects by "assigned to" and NOT TO BE A REPORT??
Hello beautiful community of SmartSheets, The client wants to use the card view of smartsheets but not in smartsheets itself but via Microsoft Teams, which is a great integration platform, the problem is that when you integrate a report via teams, is "View Only" so the client can't move the cards around or check tasks that…
-
If cell A contains specific data, populate cell C with data from cell B
Hello Smartsheet Community! I hope that everyone is well and had a Happy Thanksgiving, for those of you in the States! I need some formula assistance for what I'm trying to accomplish. I have (3) columns: A - Veggie Type, B - Veggie Qty, C - Total Potato Qty If A - Veggie Type is "Potato", I want the C - Total Potato Qty…
-
Count Number of Cells that Contain Certain Text?
Hello, I am trying to count the number of cells that contain certain words, such as "NYSEG" or "RGE," when the cells may contain more than one of these words. I have tried using =COUNT(FIND("ConEd", [Utilities]:[Utilities])), but it always turns back a 1 (no matter how many cells actually contain "ConEd"). I am trying to…
-
Unparseable Error
I'm getting an error #UNPARSEABLE for the following conditional formula that sets Red, Yellow, Green, Blue symbols per combined conditions of [End Date]'s proximity to "TODAY" + Status Condition (Not Started, In Process, Complete): Formula:…
-
Tracking Date versions
Hi @Paul Newcome I have one problem statement. Please provide your idea/solution in the below example Problem Statement: We have columns set up to track the dates when version 1 is submitted, version 2 is submitted, version 3 is submitted…. Etc. We want a column that says “Two Week + Flag” in front of the columns tracking…
-
IF function + TODAY + Harvey Balls.
Hello I had this formula =IF(AND([PM % Complete]@row = 1), "Green", IF(AND([PM % Complete]@row < 0.75, Finish@row = TODAY(+5)), "Yellow", IF(AND([PM % Complete]@row < 1, Finish@row = TODAY(+2)), "Red", "Green"))) Which was working all right, but now it's not working correctly, specially when the FINISH date has past the…
-
How to count tasks across all sheets in a workspace
I have a master metrics sheet that I am using. I'd like to be able to count tasks by assigned to across all sheets in a workspace. The goal is to have this formula work if/when any new sheet is added to the workspace. Reports are not really working for me because my assigned to column is a multi-select column. I don't see…
-
How to track time in status?
I have a status column used for the tasks on projects. I'd like to track how long a task (row) stays in a particular status (e.g. in progress). I'm not quite sure how I would get this data.
-
Formula to reference sheet only if blank and certain conditions met.
How can I reference another sheet for names? I have a grid for current positions, some are filled, and some are not. For those that are not filled, column "Employee name" is blank and for those that are filled, column "Employee Name" is not blank. I have another grid with vacant positions only and it notes candidates'…