-
Index Match Help
I can't seem to get this Index Match to pull all information its just pulling certain cells and I don't know why. I've tried VLOOKUP with the same results as well. Basically I have a sheet, Business Tracker, that tracks the names of Segments, the different levels of leaders, the FTE and call volumes numbers from their call…
-
Attachment Auto Email
I need an auto flow that can email an attachment I was reading posts from 2020 that said it could be done but those options seem to be out of date. Can I automatically send attachments automatically via automated flow?
-
Return most recent date of co-located sites
I am running a yearly list of sites that are being inspected and need to return the most recent inspection date for those sites that are co-located (same address, different site IDs) I have tried using the index countifs and get Incorrect data types even though all the date columns and the co-located visit helper column…
-
Automatically adding dates to a marketing calendar template
I'm using the social media marketing calendar template. It has months, weeks and days nested, parent/child. Each day can have multiple lines under it for different posts. I would like to be able to tell it That the first Wednesday in January is Jan 1 2025 and have a formula add the correct date to each of the days in the…
-
Formula to populate field from another sheet using multiple criteria
Hi there, In one sheet ("pay scale") I have our employee pay scale and in another ("Employee Salary") I have our employees listed with their experience and education levels. Is there a Smartsheet formula that I can use to pull in their salary based on their experience and education levels? For example, if they have a BA +…
-
Nested INDEX/MATCH formula for conditional cross-sheet reference use case
I am currently using the following INDEX/MATCH formula to return values from the sheet labeled "Tech Project List" in the reference. =INDEX({Summary from Tech Project List}, MATCH([Tech List Row ID]@row, {Project ID from Tech Project List}, 0)) I now want to expand that formula to include a condition: If #NO MATCH on Tech…
-
Count "Booked" status from last week
=COUNTIFS({Activity Log - SaaS Range Status 8}, "Booked", {Activity Log - SaaS Range Date}, WEEKNUMBER(@cell ) = WEEKNUMBER(TODAY()) - 1) =SUMIFS({Activity Log - SaaS Range Amount}, {Activity Log - SaaS Range Status2}, "booked", {Activity Log - SaaS Range Date2}, WEEKNUMBER(@cell ) = WEEKNUMBER(TODAY()) - 1) Kindly help to…
-
I need help (new to formulas)
Newbie, I am curious if I can merge a Match, Index or Vlookup with an If Then statement. I have 2 sheets and I want to first validate 2 columns and find a match, then if they match, I want to use that match to pull data from a third column on my lookup_table and move or copy it to my main sheet. Is this possible?
-
Sum cells based on multiple criteria with a timeframe requirement
I am working on trying to sum the time I spend across all my projects and want to sum different columns but only when they meet different criteria. Every formula I work through doesn't seems to work. I want to sum the Duration of Meeting IF the start date of a subject is within 5 days of the date in the green box that I…
-
Dynamic Unique List?
Is there a formula or work around to return a dynamic list of unique values from one sheet to another? I'm attempting to create a "Count" of projects by project manager from a project intake sheet. I'd like the report or sheet to dynamically update if a new hire PM is added to a project on the project intake sheet.
