Formulas

Discussion List

  • Formula to return a date that always lands on Wednesday
    In Formulas and Functions
    Hi, I'm trying to create a formula that takes a date and returns a date that is the following Wednesday. So it is always a date that starts on a Wednesday. This is the formula I've tried, but it's not working. =IF(WEEKDAY([Task Name]29)&l…
    Answered - Pending Review
    9 3
    Answered - Pending Review 9 views 3 comments Most recent by bcassidy33 Formulas and Functions
  • How to display Name of the user who created record?
    In Formulas and Functions
    Created By displays email. How can I display the actual Name of the user who submitted record through form?
    Answered - Pending Review
    15 1
    Answered - Pending Review 15 views 1 comment Most recent by Krissia B Formulas and Functions
  • Another Nested IF Formula
    In Formulas and Functions
    Could use your help again. Not sure why I have so much trouble with these nested IF statements but I do! When I use the formula below and the Business Unit is equal to EMEA, it returns ASD....any ideas? =IF([Business Unit]@row = "Biol…
    Accepted
    19 11
    Accepted Answer 19 views 11 comments Most recent by David Tutwiler Formulas and Functions
  • How to Send Timed Reminders Based on a Trigger?
    In Using Smartsheet
    Hi, everyone; first post, Intermediate user. I'm hoping you can help me. I've set up a SS to send an approval request when a new line is added to the sheet from a form entry. I've got the automation figured out for approval or declinatio…
    Answered - Pending Review
    29 2
    Answered - Pending Review 29 views 2 comments Most recent by StevieSango Using Smartsheet
  • Using COUNTIFS with CONTAINS
    In Formulas and Functions
    Hello, I have a contact column where some rows have more than one person assigned to a task. I want to count the number of tasks assigned to any given individual. This is the formula that I have created to do this: =COUNTIF(CONTAINS("…
    Accepted
    2438 15
    Accepted Answer 2.4K views 15 comments Most recent by Genevieve P. Formulas and Functions
  • Summary formula Sum of information
    In Formulas and Functions
    Hi All Can anyone please advise on how to quantify two columns in the Summary information? I want to look at the failure column to look for keywords then sum the amount of failed items. Example look for ... OTIF and the sum of issues sho…
    Answered - Pending Review
    8 1
    Answered - Pending Review 8 views 1 comment Most recent by David Clunie Formulas and Functions
  • Bring the data in a cell over to another sheet based off of other conditions in a row
    In Formulas and Functions
    What would be the best way to bring the data in a cell over to another sheet based off of other conditions in a row? Example: =IF(AND({Sheet A Type} = "Project Status", {Sheet A Status} = ""), {Sheet A % Complete}, &quo…
    Accepted
    20 2
    Accepted Answer 20 views 2 comments Most recent by mballen Formulas and Functions
  • Dashboard with Filters - Best Practice
    In Formulas and Functions
    Hi all, I am pretty new to Smartsheet and will need your help to build a dashboard. What is the best practice to create one? GRID I have multiple salespeople in my team, each of them have their own grid. The grid looks something like this…
    Answered - Pending Review
    1923 7
    Answered - Pending Review 1.9K views 7 comments Most recent by cmore04 Formulas and Functions
  • Cross Sheet Joining Automation
    In Formulas and Functions
    Hello Community, I am attempting to make a few helper sheets try to consolidate information into one row. Background: I have multiple sheets that have hundreds of parts/items from a range of vendors. I am hoping to implement a checkbox th…
    Answered - Pending Review
    62 3
    Answered - Pending Review 62 views 3 comments Most recent by Devin Lee Formulas and Functions
  • Ranking without Duplicating Ranks
    In Formulas and Functions
    I used the RANKEQ function for the first time recently and realized that any identical values will have the same rank. It will skip however many duplicates you had in the ranking numbers, so you may have a ranking scheme that looks like 1,…
    533 10
    533 views 10 comments Most recent by Devin Lee Formulas and Functions