-
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.
-
Formula helper column not updating dropdown values correctly
Hello. I have a "Responsible-report" helper column that captures a value from a field in the "Responsible" column and flows up to all the ancestors. =Responsible@row + CHAR(10) + JOIN(DESCENDANTS(Responsible@row), CHAR(10)) I updated the menu dropdown options in the "Responsible" column and the fields that were "incorrect"…
-
How to apply max function in smart sheet?
Good day everyone, I'm new to smartsheet thing and I keep searching at google for the correct answer but unfortunately I failed. I just want to get the latest date in another sheet. I found a formula online but it only get the first date match in a column. What I really want is to get the latest date value: My formula:…
-
Multiple Contacts Formula
Hello Smartsheet Community! I have a grid or sheet where we have listed out all of our projects in columns across the top and all of the supporting roles to each project down the left side. I have created a sheet to calculate all of these people but when I do the formula ( =COUNTIFS({CFPT Matrix - All Projects Range 3},…
