Formulas and Functions

Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.

Discussion List

  • Count If and Not blank
    In Formulas and Functions
    Hey everyone, I am trying to count cells in a column where one column is not blank and cells in the other column matches a certain criteria. The columns are: Responsible Department - I want to count the cells in this column that are not b…
    Accepted
    104 6
    Accepted Answer 104 views 6 comments Most recent by Valerie_WPA
  • Workflow for adding a record from a form
    In Formulas and Functions
    My sheet has a form where people request a service. Filling out the form creates a record in my sheet. I also have a workflow that sends the requestor an email confirmation, with the details of the request, when a new record is added to …
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by Andrée Starå
  • Automated Workflow Execution Time
    In Formulas and Functions
    I have created several automated workflows, which should be initiating as soon as something changes in the sheets, however to get it to work I am having to save and refresh my page every time. Have I made a mistake when creating the workfl…
    Answered - Pending Review
    14 1
    Answered - Pending Review 14 views 1 comment Most recent by Anupriya
  • Counting tasks throughout the year
    In Formulas and Functions
    Hi, I'm counting how many times certain tasks has been added to the list of TO DO of the year, Meaning for instance if one of my teams (there are 4) has added to the list of day1, task1, and task2 (a different color for every task). My pro…
    Answered - Pending Review
    16 1
    Answered - Pending Review 16 views 1 comment Most recent by Anupriya
  • Record changes to only 1 cell
    In Formulas and Functions
    In a sheet where another user and I download files and mark them in different stages (proofed, processed, uploaded), is there a way to record who last modified a cell rather than a whole row? I'd like to have a cell automatically record wh…
    Answered - Pending Review
    8 3
    Answered - Pending Review 8 views 3 comments Most recent by Andrée Starå
  • how does the formula work for duration column when predecessor activated
    In Formulas and Functions
    I am getting a #invalide data type in some but not all rows.
    Answered - Pending Review
    11 3
    Answered - Pending Review 11 views 3 comments Most recent by Anupriya
  • IF/AND cross-sheet formula not working
    In Formulas and Functions
    Hi all, I'm trying to create a column formula but only select one date out of 2 available. Current layout of my sheet is as below: What I'm trying to teach to the system is that if Global lead is not equal to X and Regional Start-Up Date (…
    Answered - Pending Review
    9 1
    Answered - Pending Review 9 views 1 comment Most recent by mattstoc
  • Dashboard, column cut
    In Formulas and Functions
    Dear all I have created this Dashboard from a report and on the first column (see picture) value/text is not shown completely - actually it should say LAUFEN. This BRAND column is not the primary column and the Align cell function is also …
    PRZ Profile Photo PRZ
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Joe Goetschel
  • Hyperlink function
    In Formulas and Functions
    Based on community articles, I am confused if the Hyperlink function exists or not. Regardless, here is what I am trying to accomplish. In the roadmap tracking sheet, I have a column "Assigned Team". Each team has a workspace wi…
    Unanswered
    7 0
    Question 7 views 0 comments Started by Vadim K
  • Counting Instances Across Sheets
    In Formulas and Functions
    I am building a dashboard for each of the colleges at my university. I originally created a Smartsheet for each college that lists all of the courses in each of the programs in the college, documenting whether or not we have a course maste…
    Accepted
    299 47
    Accepted Answer 299 views 47 comments Most recent by Chris Neary