-
VLOOKUP issue
I am trying to pull totals from my 2023 sheet into my 2024 sheet. The totals I am pulling are in a different column but same row as where I want them, so I decided to use VLOOKUP. 2023 Sheet: 2024 Sheet: I want 'Total 2023' to be pulled and placed in 'Previous Years Total' for each corresponding row. My formula:…
-
Year-to-year best practices when it comes to metrics based on dates?
Greetings- I need some advice in regards to best practices when it comes to tracking multiple years and what to do when one year ends. For example, my SS below tracks submissions via the form by month and year using the formula below for January. =COUNTIFS({Community Engagement Request Range 1}, "1", {Community Engagement…
-
Formula Help - Childre
I recognize that this is probably very easy and there are several topics on this already in the Smartsheet community. I swear I have searched them all and the suggested solutions are just not working for me. Any guidance is appreciated. I've created a very generic task list, that includes columns for Start Date and End…
-
Auto fill
hello I hope this message finds you well. I am currently working on a project where I have a sheet containing columns for tasks, locations, and tasks under different child categories. I am looking for assistance in creating a formula to automatically fill up the location column in the main row category with the…
-
Can anyone recommend a easy way to change a date range in a SUMIFS function?
I have a SHEET where the columns need to reference a progressing month date range in a SUMIFS function. Is there an easier way to use a function other than referencing two specific date ranges in a different sheet? My formula is the following: =SUMIFS({450 - INVOICE ENTRY SHEET Range 1}, {450 - INVOICE ENTRY SHEET Range…
-
Count if - multiple categories for budget
Hello! I am trying to create a formula for a budget tracker that can count up our monthly cost centers & spend without having to create individually formulas for each center. The current formula for an individual cost center is: =SUMIF([Cost Center]13:[Cost Center]271, "20101 West Events - Samantha", January13:January271)…
-
Task that lasts the duration of the project
I have a task I want to track that lasts the duration of each project. However, since the start/end dates can't be formulas, I'm wondering if there's another way to set this up in my template?
-
Dollars and Cents entered on a form not translated in currency to the Sheet
Our employees fill out a text number form and the corresponding column is set to currency, however, if the amount is "1537.40" and our employee enters "1537.40", the column returns a value of "1537.4" I looked in the forums and could not find a solution to this. If we set the column to currency for default, why does it not…
-
Date Formula
Hello, We are trying to report on the data at the end of each week. Each individual fills in the form each day. What I want to be able to do is total their information every Friday and report the Friday date. So if they enter in today's date, 01/25/2024, I want the helper column to return 01/26/24, however I am receiving…
-
SUMIFS with Has Formula not working
Hi all I'm working on a formula in a summary sheet field and its not giving me the correct answer. It should be giving me a 0 and it's giving me 3.5. I can't figure out what's wrong? Any thoughts? =SUMIFS([PM Hours / Week]:[PM Hours / Week], [Imp Product]:[Imp Product], HAS(@cell, "VItalHPI"), [End Date]:[End Date],…