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

  • RAG status formula using TODAY and end date
    In Formulas and Functions
    Hey smartsheet community, any help fixing this RAG status formula? I am trying to automatically show RYGG balls dependant on the end date and today's date. With the exception of cancelled and complete tasks; any task with the end date TOD…
    Answered - Pending Review
    103 6
    Answered - Pending Review 103 views 6 comments Most recent by [email protected]
  • How to troubleshoot the error in a formula? I am receiving #UNPARSEABLE error
    In Formulas and Functions
    I am using a simple if statement but receiving a #UNPARSEABLE error for the formula: =IF(([Proposed 2020 Base Salary]@row-[2019 Base Salary]@row)/[2019 Base Salary]@row=-100%,"",([Proposed 2020 Base Salary]@row-[2019 Base Salary]…
    Accepted
    12 2
    Accepted Answer 12 views 2 comments Most recent by Sonal Dubey
  • To Pull a recent status from another sheet
    In Formulas and Functions
    Hi Hope you are doing well. I have one sheet "Sheet 1", in which we have 2 fields that will be filled through the form. One for scanning the barcode of the Product and 1 for updating the status of the Product Process for ex- Raw…
    Accepted
    26 5
    Accepted Answer 26 views 5 comments Most recent by Paul Newcome
  • Form Submission creating new row - cant do notification
    In Formulas and Functions
    I have a sheet which has 10 columns. It is meant to collect data and trigger notifications. The first 4 columns, I have created a form to collect data from user. The 6 other columns are for tracking on status and assigned to user column. T…
    Answered - Pending Review
    19 3
    Answered - Pending Review 19 views 3 comments Most recent by Genevieve P
  • Is there a formula for what I have described below?
    In Formulas and Functions
    I want to add or subtract a row in a separate column when another column’s row has data. Basically I have a master column that houses certain numbers one being 46. I have other columns that are name Date item added and Data item removed (D…
    Unresolved
    22 2
    Question 22 views 2 comments Most recent by Richard Trader
  • Automation in Workflows
    In Formulas and Functions
    How can I Request an update to separate person as per the specific data in the form. For example, we have 4 department named Dept 1, Dept 2, Dept 3, Dept 4 and we have 4 separate managers for each department M1, M2, M3, M4 respectively. No…
    Answered - Pending Review
    7 1
    Answered - Pending Review 7 views 1 comment Most recent by Heather D
  • Using forms to update a record
    In Formulas and Functions
    I've perused the Smartsheet community posts for the answer to this question and get varying results. Objective: Use a Smartsheet Form to update a row (a record) of data. Background: We are currently using an Excel file with a VBScript fo…
    Answered - Pending Review
    16 7
    Answered - Pending Review 16 views 7 comments Most recent by Heather D
  • Formula to count of items in a multi dropdown list
    In Formulas and Functions
    Hi The drop-down multi select is very nice and useful.  I started to use it yesterday, but I need to use the formula =countif(range, criterion).  I want to count how many times a value is repeated in a range that has multi values. I use …
    Accepted
    16666 36
    Accepted Answer 16.7K views 36 comments Most recent by Paul Newcome
  • Auto Allocating A Person
    In Formulas and Functions
    Hi I maybe asking a bit much here but, here goes..... I want to be able to allocate a person to a task based on the Dept and Quarter No. I have set up a File Review Allocations sheet that shows the number of file reviews required per yea…
    Accepted
    20 6
    Accepted Answer 20 views 6 comments Most recent by Bassam.M Khalil
  • Does @row work in a summary field?
    In Formulas and Functions
    I am trying to return a date from a created column based on whether a multiselect dropdown contains a certain value. I'm using If and Has but when I refer to the Created column it does not work
    Answered - Pending Review
    28 11
    Answered - Pending Review 28 views 11 comments Most recent by Genevieve P