-
How to get a column to state a status off the health color indicator
Hi, I have a column with colored health status of some project tasks, due to the fact in email updates and that you cannot see the colored got in the email, I am hoping to add a column that with align with the colored dot column with words so those getting the email can see the health if the item. So just looking to have…
-
INDEX MATCH ERROR WHEN CONVERTED TO COLUMN FORMULA
Hi fellows, I've a Destination sheet (SHEET 1) and a Source sheet (SHEET 2). In SHEET 1 i've set the following INDEX/MATCH formula for all the cells in col. B: =INDEX({SHEET 2-Col. B}, MATCH(SHEET1-Col. A, {SHEET 2-Col. A}, 0)) that works exactly as the following VLOOKUP formula (n col. B): =VLOOKUP(SHEET1-Col. A; SHEET…
-
Add a date (first of month)
Hi there! We have a smartsheet that is for program enrollment. The program start date is the first day of the following month after the enrollee's start date (so, if they start on 11.15 in their office, their program start date is 12.1). I originally used: =DATE(YEAR([Net Add Start Date]@row), MONTH([Net Add Start…
-
Weekend date Formula in text/number column
Hello everyone, I am trying to create a table in which the first row has the week-end dates (week ending Friday), instead of putting the dates manually, is there any formula I can use? Please note that I need the columns to remain in text/number format only
-
Formula Help
For project resource hours that I am trying to tally I am trying to look across multiple date columns, locating all the dates for a specific month, and then based on that, tally the total number of hours in multiple cells that pertain to those dates. I am not quite sure how to go about it. So far I have some up with (at…
-
using a COUNTIFS formula and @row
Hi there, I need assistance with formatting this formula: =COUNTIFS({Program Name}, (@cell), {Program Name}, [Program Name]@row)) My goal is to count the number of attendees per program session in our dynamic list. Given that the list is regularly updated with new program names, I'm seeking to count the rows based on each…
-
At Risk formula include when Status is <blank>
Getting started in Smartsheets for Project Management. I've been reading a number of Q/A on creating formulas to flag At Risk. I want to flag any task 3 days before the End Date or if it's past the End Date. Additionally, flagging any task where the Status is NOT Complete. Here is what I've been using so far: =IF([End…
-
How to create a top 5 list without duplicate values
Hey there, I am trying to create a top 5 list of values from a large table of information. the idea is that you would be able to see which "ATA Chapters" have the highest figure next to them, for example if you look at the attached image "ATA 25 - Equipment & Furnishings" has a total of 5 in its row if you add the numbers…
-
Index/Match situation.
Hi, I apologize in advance, but I've been searching, and trying to figure out how to do this, and I guess I am just not understanding things (or it's not possible). I have 2 sheets. One is a checklist for all new stores. The other is a checklist for the IT installation of stores for a particular week (though I'm not sure I…
-
Is there a way to count a certain column based on the day of the week?
Is there a way to count a certain column based on the day of the week? what I want count the "Hold" (Yellow Box) in the Monday column if today is Monday or count the "Hold" (Yellow Box) in the Tuesday column if today is Tuesday..... continued for each day This is my current formula =COUNTIFS({Daily check Monday}, "hold" +…