-
Adding a Date require to IF statement
Hello, I'm looking for assistance in adding some criteria to this AVERAGEIF formula to make it so I am only averaging dates from this year. =AVERAGEIF({Completed - Department}, =[30 Day Post Release Quality Score - Segments]@row, {Completed - AQualityP30D}) There is no AVGIFS so I'm not sure how to appraoch this any…
-
Need to add 6 months and 3 months to a date
I have a date that other will populate, but I need to have two columns that calculated 3 months out from the date and 6 months out. I have tried several formulas on the forum and nothing is working. I am completely stumped. If I was in excel this would have been done in a minute.
-
COUNTIF referencing another sheet
I am needing to count the number of rows that are classified as rolling deadlines. The data I am trying to reference is in a separate sheet. This is the formula I currently have that is giving me the #UNPARSEABLE error. =COUNTIF({Proposal Tracker Range 1}[Deadline Type]:[Deadline Type], "Rolling Deadline") Please help me…
-
Fprmula to count date with 2023 as year
Hi im trying to add the week number only for projects with 2023 dates. the below only counts all week number but doesn’t distinguish between year. can you help =WEEKNUMBER([ACTUAL - Site Acceptance Completion Date]1)
-
Show Last Non-Blank Text Cell in Row
Hi Everyone, Hoping you can help because I'm stumped. In the 'Most Recent/Current Project' column pictured below I am trying to add a formula that will show the text within right most cell that is not blank. I've tried two methods that work in Excel, but the formulas don't seem to be usable in SmartSheet. In Excel, I've…
-
COUNTIF not returning correct amount of rows
hi i have a formula in my sheet summary that uses a countif formula to to count how many rows contain "Eng Ops" in my "Function" column. the formula puts out 31 as the answer but when i filter the sheet to show rows containing "Eng Ops" they're 35 rows. =COUNTIFS(Function:Function, CONTAINS("Eng Ops", @cell))
-
How do I count if someone attended?
Hey! I've been messing with this formula for a bit, and I'm kinda stumped. I'm trying to count how many people have attended a course on a certain day. So, if "Attended" is checked on 1/23, then that should count as one person attending. Columns Referenced: Attended = Check Date = Date format…
-
Best method for saving updates across 2 sheets
Hi, I hope all reading are well! I have a question relating to the best way of obtaining updates across 2 smarsheets. Sheet 1 contains multiple columns of data, which are imported on a weekly basis from a 3rd party app. Each week the data from the previous data is overwritten with the new data. In Sheet 2 I would like to…
-
Update a cell on a master list from individual identical laid out sheets
I have a template that I use to create data sheets for unique projects. All rows and columns are the same for each project. I also have a master sheet that lists all the projects which are populated with information from the same cell location from each project sheet. I have been able to go from the master sheet to the…
-
Automate symbols
This should be easy but I am stuck trying to figure out how to get the symbols to work in a formula to reflect health of budget percentages. All the single lines work except the green one - it just shows up blank, with no error (the highlighted drop-down has the green formula only like below) I have tried the combo forumla…
