-
Three criteria SUMIFS
Good afternoon! I am trying my hand at getting some detailed information about hours put in by volunteer by location. What I am trying to pull is from the screen shot in the two attachments. here am I messing up on this formula? =SUMIFS({Time (in yellow)}, {Location (in green)}, {Date (in blue)}, AND Location2 (orange)…
-
Sheet formulas are not auto-updating until the sheet is opened
Is this still a known issue with the TODAY() function OR is there a way to get around it? https://community.smartsheet.com/discussion/59131/sheet-formulas-not-auto-updating?_gl=1*hx7amf*_ga*NDg5OTI2NTg5LjE3MDYwMzk4MDY.*_ga_ZYH7XNXMZK*MTcwNjgwOTkzNi41LjEuMTcwNjgxMDAwMy41OS4wLjA.
-
How do I convert dates into a time period (month) for reporting?
I am creating a savings dashboard and my primary sheet records the date the PO is issued. In my dashboard I want to display my savings by month or fiscal period. Is there a formula that will convert my rows with PO issued dates between date ranges into a fiscal period/month. Example: I want to convert row cells with any PO…
-
Help with Collecting Data for Metrics w/Multiple Criteria
I need help to collect a sum of financial information based on a range of dates in the future (or past) SmartSheet Name: Renewals-Active Column Names: 'MRC' is a text/number column and contains the financial information 'Estimated Contract Exp. Date' is the date column that contains dates (past, today and future) 'Primary…
-
How to combine these formulas
=INDEX({Do Not Use Art List Range 1}, MATCH([Distributor Name]@row, {Do Not Use Art List Range 2}, 0) =INDEX({Do Not Use Art List Range 1}, MATCH([ARTNAME}@row, {Do Not Use Art List Range 2}, 0) I can get these two formulas to do things on their own but can't put them together right to get the same result. I don't need…
-
INDEX MATCH is matching same values to everything
Good morning all, I'm having some issues with this INDEX MATCH, that are really stumping me. Here is my formula: =INDEX({NE INVOICES Range 4}, MATCH([PO#]@row, {NE INVOICES Range 1})) And here is what I'm getting: This would normally be fine, as those PO's don't exist on my source (Here is the source sheet) The issue is as…
-
Can I get Unique values on a metric sheet without a complicated work around or report?
I have a column with associate names, over 3,000 rows with over 100 unique names. In order to provide dashboards, I need a dynamic list of unique names listed in that column on a sheet I use to build our KPI metrics. Easy in excel or any other dashboarding tool I use, is this now possible in Smartsheet without using the…
-
Adding year to quarterly equation to count
I want to count how many projects in each network have expected completion dates within the quarter per year. For example, in Upstream, I know 3 projects will complete in Q1 2024 but 1 will complete in Q1 2025. The formula I'm using won't account for the year and count correctly for what I know are the actual expected…
-
Is there a way to have text repeat all the way down the primary column?
Is there a way to have text repeat all the way down the primary column, even when new rows are added without having to manually enter? I am trying to use this as a helper column so this is what displays in the calendar.
-
How can I use a function to pull dates from Sheet A to Sheet B?
I have a master sheet of dates for multiple programs and projects. The layout of the sheet is: Program | Project | Start Date | End Date Each program is divided into hierarchies as such: Program A --Program A-1 ----Program A-1 | Project A | Start Date | End Date ----Program A-1 | Project B | Start Date | End Date…
