-
Multiple IF Formulas Based off a Date
Hello Everyone, I'm trying to create a formula with multiple IF statements. So far, I have the following created: =IF([OH Date Qualified]@row < TODAY(-1080), "Designer 2"), IF([OH Date Qualified]@row < TODAY(-1800), "Designer 3"), IF([OH Date Qualified]@row < TODAY(-3600), "Designer 4") However, the above formula only…
-
Retain "Thousands format" when concatenating cells
Hello, I have two cells, "Amount Requested (local)" and "Local Currency Type" that I want to be concatenated in a single cell. I want the amount requested to retain the "," that is added by using "thousands" formatting Here is my current formula, is there anything I can change it to so that it spits out "980,425 Euro"…
-
Countifs projects starting or ending this week in sheet Summary formaulas
Hi all, I need help on a formula to gather how many projects are due to start this week. I have this so far, but it returns 0, but one date range is within the parameters. =COUNTIFS([Target Start Date]:[Target Start Date], WEEKNUMBER(TODAY())) I also need to count on the [Target End date] on how many are due for completion…
-
Formula to return a status based on due date
Hello, I am trying to return a status for projects based on due date. I have a date column for Due Date that has some blanks and another column for the Status. In the Status column I have the following formula: =IF(ISBLANK([Due Date]@row), "", IF(WEEKNUMBER([Due Date]@row) = WEEKNUMBER(TODAY()), "This Week")) This is…
-
I want to update a cell if any of the cells in a certain range of cells equals a certain text.
If ANY cells in Status3- Status7 = In Progress then I want Status2 to equal "In Progress, If ALL cells in Status3-Status7 = Complete then I want status2 to equal "Complete" @Paul Newcome @Andrée Starå
-
Formula for today's date as day ___ of 365?
Hi there! I need to make a simple dashboard metric widget displaying the current day's date as day ___ of 365, as a percentage. Even more specifically, if possible, I need to do this same thing for today's date as day ___ of [number of days in current quarter], as a percentage. Examples: Today is Feb 18, which is day 49 of…
-
Formula needed: Multi drop down select column to output value in another column
Hi All, Any help with a formula? This is driving me nuts! Basically what we're hoping is to be able to select multiple values within the "Rate_Card_Tactic_T4/T5 column", and output the dollar amount that is assigned to that tactic in "T4/T5 Cost - Email Blast" column. This is as far as I've gotten... it works only if I…
-
Formula to value cell based on 3 other cells
I'm struggling how to write a formula for a Job Status Column, which is based on whether or not 4 individual date columns have a value in them. If date Column 1 has a date, then the Job Status Column should automatically show as "25% Complete". If date Column 2 has a date, then the Job Status Column should automatically…
-
COUNTIF FORMULA (3 Columns, 1 Column includes contact)
Hi All, Need help with a formula! I need a formula to summarize the following criteria. If Project Track = XX, and if Project Phase = XX and if Project Manager = X Person" what is the output? My current formula, but it doesn't seem to be working. Is it due to the fact that the Project Manager filed is set to contact list?…
-
Link latest update from one smartsheet to another
Hello everyone! I am having a bit of trouble trying to come up with a formula that will automatically pull the latest update from one smartsheet and copy it to a cell in a different smartsheet. The latest updates are entered via a form by the users and the latest rows are shown at the top of the sheet: I want to copy the…