-
Newbie: Using COUNTIF to calculate uses of a text string on another sheet
I think I've reached the limits of my self-teaching and could use a little guidance. I have a sheet called Assigned Categories that includes a Category column. That column is a multi-select drop down list and we've made multiple selections in each row. I have a separate sheet called Statistics with two columns: Name and…
-
Reporting Earned Value vs Planned Value for SPI Metrics
Good afternoon everyone, I'm new to the SmartSheet community, but my company and I have been integrating SS into our PM work processes for about 1.5 years. We're a VOSB DOD contractor, and we use SS to create simple project schedules that include start/end dates, duration, dependencies, and % complete. We do not resource…
-
IF AND Statement for Color Statuses
I am trying to do something that I thought was fairly simple, but I keep running into an issue and receive an "#Unparceable" with my current formula. I am trying to build a Task Status based on Red, Yellow, Blue, and Green Circles. My challenge is getting the proper formula/syntax for my Yellow Status. =IF([Status]1 = ???,…
-
What function can I use to fetch the most recent value of a duplicate (some name)
My question is this I am struggling to understand what function I need to use so that it returns the most recent value I have added in the column. I want to know how to make the VLOOKUP function return the last value I added to the array as of now it only returns the 1st value it sees(scanning from the top downwards) I…
-
Multiple columns condtional furmola/formate
Hi , I have fleet of cars my drivers manually on daily basis type the KM/Millage reading in Column (Km/Today) I need formulla for column Alert as follows: - - - - - - - - - - - - - - - - - - -- - - - If number in col (Oil Next) is less than col ( Km/Tiday) the alert Col is (Green) AND If number in col (Oil Next) is Higher…
-
Count Unique Assigned to values with a Specific Status
I have a COUNTIFS formula that I use in a roll-up sheet to count the number of tasks specific individuals have assigned to them on a Project Task Sheet. The values from the roll-up sheet are fed to a dashboard. =COUNTIFS({Assigned To}, Primary9, {Status}, <>"Complete") The problem with this formula, is that it does not…
-
Countifs between two dates, multiple sheets
Sheet 1 has a column "Date Conducted". Another column "Status" with dropdown options "Safe" and "Improve" Summary Sheet has two columns, "Start Date" and "End Date". On the summary sheet, I'm trying to count the number of "Improve" where the "Date Conducted" is between the "Start Date" and "End Date". Any ideas? Thanks!
-
Add Source Sheet When Copying Rows to New Sheet
Is it possible to put a link to the source sheet that a row was copied from in the copied to sheet with a formula so it adds the source each time? Sort of like a report will give the source sheet. I'm copying rows to a rollup sheet, but I'd like the roll up sheet to have the link so it is easy for the used to go to the…
-
IF Statement needs to ignore blank cell sometimes
Sometimes there are two approvers, sometimes only one. If there is only one and they "Confirm", I record a date column otherwise not and my workflow runs. Sometimes there are two, if they both need to "Confirm" and then I record the date column. If either rejects I don't record the date and run a workflow. The problem I am…
-
Previous Month formula
Hi I'm in the process of creating MTD and Previous MTD helper columns. If the Create Date is current month, I want to check a box. I have this formula working perfectly. What I'm struggling with is previous MTD. If the Create Date is the previous month, then check a box. If the Create Date is older than previous month,…