Formulas and Functions

Let the community help you with that tricky formula or function! See how others are utilizing the power of formulas and functions to save them time and create more powerful solutions with Smartsheet.

Discussion List

  • Can I Disable Rollup Percentage
    In Formulas and Functions
    Hi, I'm working in a Master SS that all departments are contributing information into. My particular project is being run in a separate SS and I'm only pulling 5-6 line relevant line items in and linking them to the Master SS. Those 5-6 …
    Answered - Pending Review
    11 2
    Answered - Pending Review 11 views 2 comments Most recent by Andrée Starå
  • Is there a formula to calculate loan payments?
    In Formulas and Functions
    I need to calculate the periodic payment of a amortizing loan with level payments and a constant rate of interest. Is there a formula that I can use in Smartsheet to make this calculation?
    Answered - Pending Review
    13 1
    Answered - Pending Review 13 views 1 comment Most recent by Aravind GP
  • Can Isblank be used for more than one cell?
    In Formulas and Functions
    I want to show if a column/cell is blank. I've used the formula =IF(ISBLANK([Tutor Name]@row), "Not Complete", "Complete") It works for one cell/column, however I have a range of 5 cells/columns. How do I connect the f…
    Accepted
    11 3
    Accepted Answer 11 views 3 comments Most recent by Andrée Starå
  • Column formula do not appear in form
    In Formulas and Functions
    Hello, Hope you all are good in this crazy time. I'm really new in smartsheet and maybe what I'm trying to do is not viable, so I'll try to explain myself as details as possible: I want to create a form with some fields "auto-fillabl…
    Accepted
    8 1
    Accepted Answer 8 views 1 comment Most recent by Neil Watson
  • Setting a status based on date fields
    In Formulas and Functions
    Is there a way that I can update or set a status based on data in 3 other fields? What I am trying to do is set a status based on data being entered in 3 other fields - if those fields are blank, then status would be 'In Progress' if those…
    Answered - Pending Review
    6 1
    Answered - Pending Review 6 views 1 comment Most recent by Mark Cronk
  • Filtering on dashboards?
    In Formulas and Functions
    I'm new to smartsheet and trialing it at the moment. I have a question, I hope you can help me with: I have a portfolio of companies in a main sheet and their debt issues, and related stuff in several sheets. Rows are companies/debt issue…
    4537 51
    4.5K views 51 comments Most recent by firestorm
  • Issue with countif and find formula
    In Formulas and Functions
    Hello, I am trying to have number of projects owned by Project manager I have used this formula : =COUNTIFS({Digital Project Portfolio Plage 1}; FIND("[email protected]"; @cell) > 0; {Digital Project Portfolio Plage 2};…
    Accepted
    17 1
    Accepted Answer 17 views 1 comment Most recent by MCorbin
  • Workflow will not trigger if cell has formula
    In Formulas and Functions
    Hi all, I have a sheet with e.g. a cell with a function that calculates someting. The workflow should copy the line if the computed value = 1, but the workflow will not trigger. If I delete the formula and enter manually "1" then…
    Answered - Pending Review
    11 1
    Answered - Pending Review 11 views 1 comment Most recent by MCorbin
  • Index Match or Index Collect with multiple criteria
    In Formulas and Functions
    I'd like to return a Contact to a cell if two criteria are met. I've tried using the index collect formula copied below but I continue to receive #INCORRECT ARGUMENT SET. =INDEX(COLLECT({Vendor Contact}, {Project Name}, [Project Name]@row,…
    Answered - Pending Review
    349 17
    Answered - Pending Review 349 views 17 comments Most recent by Shelby
  • Formula column with manual entry
    In Formulas and Functions
    Hi all, Can I create a formula for a symbol column which would automatically change the priority to a "Low" symbol if another checkbox column has been checked? I would like to retain the ability to manually edit the priority colu…
    Answered - Pending Review
    10 2
    Answered - Pending Review 10 views 2 comments Most recent by Andrée Starå