-
Formula ideas
So here goes; sales sheet - contains sales monthly by postcode (RevPC} and name {RevPN} Sheet B - wants a formula to pull monthly rev data from the sales sheet if postcode and name match I just cannot get it right and cannot think where to start whether if statement and vlookup etc, sumifs .... help please??
-
Percent Complete Plan Formula
Smartsheet Community: I am Tracking Plan VS Actual and have a % Complete Formula to Track The Plan. However, My Formula is at 100% Complete for Plan, but the due date is 11/28/22. Therefore, it should be Calculating 100% Complete as of Today. Does anyone have any idea where in my formula is incorrect? % Complete (Plan):…
-
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…