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

  • Populate a cell with today's date when status is marked complete
    In Formulas and Functions
    Hi all, We have several task schedules that people use to track the status of their work. When the task is finished, they change the Status to Complete and the Percent Complete to 100%. We would also like to know the actual date the work…
    Answered - Pending Review
    34 5
    Answered - Pending Review 34 views 5 comments Most recent by Andrée Starå
  • Checkbox formula using =IF(OR
    In Formulas and Functions
    Hi, I am trying to find a formula to check a box based on another cell in the row having either maintenance OR support (along with other text) but keep getting an #INCORRECT ARGUMENT SET error.   The formula works perfectly for one crit…
    507 22
    507 views 22 comments Most recent by Andrée Starå
  • Question on SumIFS
    In Formulas and Functions
    We're hosting a "Bike to the Moon" where our supporters are uploading their daily trips, miles and emails in a worksheet. We want to display a riders' individual trips (showing date and miles traveled) and a total miles field tha…
    Answered - Pending Review
    13 3
    Answered - Pending Review 13 views 3 comments Most recent by Andrée Starå
  • Can selections from a list be added to each row under a job based on job criteria?
    In Formulas and Functions
    I am not thinking this is a possibility, but thought I'd ask in case I missed something. Can a list of tasks be populated in the rows under a new job row based on criteria in a different row? For instance, I have a column for project typ…
    Answered - Pending Review
    2 1
    Answered - Pending Review 2 views 1 comment Most recent by Andrée Starå
  • Keeping track of dates
    In Formulas and Functions
    I want the time a specific cell is edited to be automatically placed in a cell. I don't want to use the column setting because that updates when any cell in the row updates and not just the one I want. Is there a way to do this?
    Answered - Pending Review
    2 1
    Answered - Pending Review 2 views 1 comment Most recent by Andrée Starå
  • Formula within a formula
    In Formulas and Functions
    Good afternoon everyone, I was wondering if it is possible to do an IF formula with a date formula in the same cell? I would like to do the following, but also subtract the number of working days between two dates. IF([email protected] "…
    Answered - Pending Review
    4 2
    Answered - Pending Review 4 views 2 comments Most recent by Laurie
  • Gnatt Sheet Calendar
    In Formulas and Functions
    On the Gnatt Sheet, can you have multiple duration columns to show multiple dates within 1 row? Thank you! Tiffany
    Accepted
    12 5
    Accepted Answer 12 views 5 comments Most recent by Andrée Starå
  • Simplifying SUMIFs formulas
    In Formulas and Functions
    Hi In my summary sheet, I am calculating the total of all CEs value for all my Agents using the following formulas: (Image) =SUMIFS([CEs:CEs], [Agents:Agents], "Agent1") + SUMIFS([CEs:CEs], [Agents:Agents], "Agent2") …
    xav Profile Photo xav
    Answered - Pending Review
    13 2
    Answered - Pending Review 13 views 2 comments Most recent by xav
  • Help with Count If formula on unique values only
    In Formulas and Functions
    I am trying to add a count to my sheet summary which gives me the number of contracts which are a certain status within my sheet eg. pending, signed & returned etc but each contract can be listed a number of times within the sheet and …
    Answered - Pending Review
    2 3
    Answered - Pending Review 2 views 3 comments Most recent by Ramzi K
  • Trying to Input a formula to automatically generate a symbol
    In Formulas and Functions
    I have a column where I am tracking percent met and I want that percent to trigger a symbol in the column next to it. The symbols I am using are the 5 circles (Empty, Quarter, Half, Three Quarter, Full). This is the code I tried =IF([Perc…
    Answered - Pending Review
    2 2
    Answered - Pending Review 2 views 2 comments Most recent by Paul Dieterich