-
SUMIF plus COUNTIF
Hi all, I asked another question in this thread. I now want to take a step further. I would like for the formula to sum the amounts in the SAR Loss column of my other sheet only if the Date Filed is between <Date 1> and <Date 2> AND the subcategory type matches @row. =SUMIFS({Date SAR Filed}, >=DATE(2024, 1, 1), {Date SAR…
-
Is a blank date cell "not in the future"?
Working with automation, conditions, where date field is set to "is not in the future". How does that work with a blank field? Is a blank date field considered "is not in the future"? Or do I need to add an "or" date field "is blank" to this? (same goes for "is not in the past".
-
Help Extracting data sets that meet criteria to new sheet.
Hello, I am new to smart sheets. I have spent the last week trying to find a solution with no luck. I am sorry if I am asking a question that has been, probably, answered a slew of times. I have a form built that collects data on visits to one of four locations. "Activity Tracker" is the name of the sheet where the…
-
Percent Complete of Status Column
I am looking to have the Parent row show the sum of percent complete for children in the status column. Based on the photo attached, the formula I am using is not calculating the "Activity 1" cells being marked complete. I am using the formula: =COUNTIFS(CHILDREN([Status]@row), "Complete") / COUNT(CHILDREN([Status]@row))
-
Matching a Date from Origin to Destination Sheet
I am running a countif formula to count the number of certain events each day. The origin sheet has the "Event" column and a "Date" column that are feeding the count to the destination sheet. The destination sheet had a "Date" column and individual columns that contain the formula showing the counts per day of each event.…
-
Struggling with Matching/Referencing values from a Multi-Select
I have a Sheet labeled Resources with a single-select column containing a list of users/contacts. The sheet also contains a column titled Hours. I have another Sheet labeled Project with a multi-select column where one or more of the same users/contacts may be selected. I have a target column on this Project sheet where I…
-
Removing Duplicates from a Report
Hello, I have a sheet with many line items, some of which share some columns that have duplicitous information. I would like to pull a report from that sheet to display certain information on a dashboard and, ideally, within the report, run a conditional format to remove the duplicate line items. I am also reading up on…
-
SUMIFS Assistance
Hello, I am trying to calculate the number of overtime hours worked for a manager by month and year. The data sheet is below and I am using another sheet so I know I need to reference this sheet but keep getting errors. I'd appreciate any assistance.
-
Permissions for non-licensed users
Hi All - I have a Smartsheet license and built out a project plan in Smartsheet which I'll be sharing with my team members who are non-licensed users. They will have editor access either way. Does anyone know if they will be able to enter or change formulas in cells which I've created as the admin? Thanks for your help in…
-
NetworkDay formula condition question
I'm looking for guidance please and appreciate any input! I was able to get the NETWORKDAY formula to work by itself. However, I am now trying to put a condition to calculate NETWORDAY if the Project Status is not "Complete". Otherwise, I want it to display the Duration field. It's not erroring, just says the format is not…