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

  • How to pull the next due date from a list of up coming dates from a different sheet
    In Formulas and Functions
    I am fairly new to Smartsheet and still getting a feel for the landscape. I have two sheets, one is my main sheet where I want the dates to be pulled into, the second sheet is where I have my upcoming due dates. Essentially what I am try…
    Accepted
    25 4
    Accepted Answer 25 views 4 comments Most recent by JBerm
  • Formula Help
    In Formulas and Functions
    HI, I need a formula for the screenshot below that looks at if 2022 Show Start Date is less than 90 days out and Rebook Plan in Place column is unchecked, assign the status column as "Red" and if checked then the status is "…
    Unanswered
    12 0
    Question 12 views 0 comments Started by Manuel Lemus
  • Countif the Month/Year matches the current Month/Year?
    In Formulas and Functions
    Current formula displayed at bottom. It counts the amount of Values in Range 1 that are created in the last 30 days. The formula works, however I'd like to change the second countifs statement, in particular the Today(-30) so that it match…
    Unanswered
    16 0
    Question 16 views 0 comments Started by Kyle Cannella
  • Did the COUNT formula change to include blank?
    In Formulas and Functions
    I want the COUNT formula to only count checked boxes. Yesterday, this was the way the formula worked today, it counts checked and unchecked boxes. Does anyone have any idea why this changed?
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Jeff Reisman
  • Display a city name based on a text
    In Formulas and Functions
    Hello everyone, I want to display a city name based on a text, for example: COLUMN A T1 = Toulouse T2 = Bordeaux T3 = Paris T4 = ... A cell in column A can contain a single character (T1) or several (T1 + T3). In column B I would li…
    Accepted
    23 8
    Accepted Answer 23 views 8 comments Most recent by Jeff Reisman
  • How to flag a row if a checkbox is unchecked for more than 2 weeks in a row
    In Formulas and Functions
    My team uses a hierarchical sheet to track weekly student attendance by checking the 'Check In Data' box if a student is present. I want to create a column or formula that will flag a row if the 'Check in Data' box is unchecked for TWO WEE…
    Answered - Pending Review
    20 2
    Answered - Pending Review 20 views 2 comments Most recent by Jeff Reisman
  • Countifs help
    In Formulas and Functions
    I have a sheet that has a column for the date and the second column that states "yes" or "no" beside the date as to if we have had an accident. This second column is called safety. I am trying to write a formula to co…
    Answered - Pending Review
    17 4
    Answered - Pending Review 17 views 4 comments Most recent by R.M.
  • Duration Counter/Timer
    In Formulas and Functions
    Is there a way in SS, that when using an auto-generated created date/time, that a duration column will count how long since it was submitted. Then have a date & a time column for completion that will stop the timer?
    Answered - Pending Review
    32 2
    Answered - Pending Review 32 views 2 comments Most recent by HardWork
  • Can Smartsheet forecast end date base on % complete input
    In Formulas and Functions
    For example: Start Date: 10 Jan 2022 (Mon) End Date: 14 Jan 2022 (Fri) For simple calculation, working day duration is 5 days. Each day should achieve 20%. Today is 12 Jan 2022 and I should achieved 60%, but I only manage to complete 40%.…
    Answered - Pending Review
    19 3
    Answered - Pending Review 19 views 3 comments Most recent by Genevieve P.
  • Excel to Smartsheet formula conversion error
    In Formulas and Functions
    Hello All, I am trying to import Scaled Agile Team Event calendar excel onto Smartsheet. I am facing difficulty in automating Column F - Team Events on Smartsheet. If someone can help me debug the query to work in Smartsheet. I am atta…
    Unresolved
    35 4
    Question 35 views 4 comments Most recent by Genevieve P.