-
Use COUNTIF with AND to add additional count conditions from other columns in same sheet
I want to count the number of times a certain parameter is assigned a certain category. I have 3 parameters that I track "incidents" for: HG, PM and SO2. In my summary sheet, I want to count the number of times in the sheet each parameter is assigned the EPA Downtime Category: "Monitoring System Malfunction" for use in a…
-
Expaning Countif to include an additional criterion
I have successfully created a countif formula to count the number of times a word appears in a column. =COUNTIF([Medicaid Enrollment Status]4:[Medicaid Enrollment Status]158, "Enrolled") Now I need to expand it to include an additional criterion, "Enrolled-Provisional" I want to count all incidences in the column called…
-
Linking multiple cells (with a caveat)
Hello Smartsheet Community! I'm trying to link multiple cells at once from the source sheet (the information is in cells across one row. They are not necessarily contiguous, but I could make it that way if necessary, which my example will show, but I would prefer not to do it that way.). To link them into my destination…
-
Conditional Formatting
Hi, I want to use conditional formatting for a budgeting sheet I'm using with 3 columns. Column 1 = Actual value, this figure is the cost for the item I'm purchasing Column 2 = Budget value, this figure is the funds allocated for the item I'm purchasing Column 3 = Delta value, this is a formula that subtracts the actual…
-
Reminders for Approvals
I am working on an Approval Process workflow and I would like to have Reminder(s) generated by the system after 2 days if the manager(s) did not approve the request yet. I have the 'Sent' status and I am planning to use the 'last modified' to trigger it. What would be the best way ? Thank you in advance.
-
Trinary outputs for IF function -AND- display metric if Reporting Month<Current Month
Hey @Paul Newcome - I bet you are the PERFECT person to help me with this as I've used many of your solutions from countless posts and you may even recognize some of your work below! 🏳️ HALP ME! 😲 In SmartsheetGOV, I track and report on staff members' Monthly Reports (July 2020 - May 2021). I have 3 Grids, 1 Form, 8…
-
Concatenate instead of adding days from a date?
Hi, I am trying to add days from a date, depending on the value of another cell. Instead of adding the days it appears to be concatenating. In the screen shot below the desired result would be an Expected Sample Date of 04/01/21. Instead it is displaying 03/01/2132. Here are the Columns I am using: Completed in Lab Date…
-
Summary Report Capturing Data From Child Row
I have been tasked to create a status update report each week, showing which projects have not been updated in 6, 4, and 2 weeks, from Wednesday of the current week. The column where I need to pull the data from has the following hierarchy: Each Wednesday, I have to drill down the project parent, and then the child of the…
-
Nest IFs coming back #Unparseable
I am trying to create a formula that returns “Green” if Project Day Variance is less than or equal to 0, “Yellow” if Project Variance is between 1-10, or “Red” if Project Day Variance is great or equal to 11. I tried to nest IFs, but I get Unparseable (see below): =IF([Project Day Variance]@row <= 0, "Green"),…
-
Does using JOIN with the End Date field that is part of a dependency not work properly?
I am trying to MATCH on two fields, so I am using JOIN to make one field. The joined fields in my reference sheet are 1. a text field and 2. the END date field. When I MATCH to that JOINed field, I get #NO MATCH. But if I copy and paste that JOINed field into another field, I do get a match. Is that END date causing this…