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

  • SUMIF Challenging Formula
    In Formulas and Functions
    Here is a tough one: Look in Column (Budget Requested) [this will always have a $$ amount in it] THEN Look in Column (Budget Approved) [this might have a $$ amount in it] IF Column (Budget Approved) has $$ amount, use that number and SUM …
    Accepted
    23 12
    Answered ✓ 23 views 12 comments Most recent by Paul Newcome
  • SUMIFS with 2 Factors
    In Formulas and Functions
    I am trying to create a formula to SUM a COLUMN/RANGE (Column Title: Budget Requested), IF a BOX is checked in another Column (Column Title: Approved). Keeps returning #UNPARSEABLE 😑
    Accepted
    11 8
    Answered ✓ 11 views 8 comments Most recent by Paul Newcome
  • Moved: Is there any way to make a task start and finish according to another task?
    In Formulas and Functions
    This discussion has been moved.
    1 0
    Closed 1 view 0 comments Started by Alejandra
  • Moved: Report with What and When requirements
    In Formulas and Functions
    This discussion has been moved.
    1 0
    Closed 1 view 0 comments Started by Alejandra
  • Report with What and When requirements
    In Formulas and Functions
    Hello community, I need your help on this report. The solution is probably very easy, I just cannot get my head around it. I have a project plan with one column "Flag" (lines can be flagged with the little red flag) and a colum…
    73 10
    73 views 10 comments Most recent by Paul Newcome
  • Help with a formula
    In Formulas and Functions
    I am developing an equipment tracking smartsheet.  One of the columns indicates the estimated lead time for delivery.  I would like to "bucket" the lead times into ranges:  0-60, 61-90, 91-120...etc. Thoughts on how to best achie…
    Answered - Pending Review
    11 4
    Answered - Pending Review 11 views 4 comments Most recent by Paul Newcome
  • Moved: Add data to existing sheet from mobile
    In Formulas and Functions
    This discussion has been moved.
    1 0
    Closed 1 view 0 comments Started by Alejandra
  • Moved: Automatically Populate Status - Sales Pipeline
    In Formulas and Functions
    This discussion has been moved.
    1 0
    Closed 1 view 0 comments Started by Alejandra
  • COUNTING MTD ENTRIES
    In Formulas and Functions
    I have been able to get YTD results with this formula: =COUNTIFS({DATE SOLD}, AND(IFERROR(YEAR(@cell), 0) = YEAR(TODAY()))) However, I am unable to get a formula right for MTD. Any assistance would be much appreciated Thanks, Jason
    Accepted
    65 9
    Answered ✓ 65 views 9 comments Most recent by Paul Newcome
  • Help with a Monster Formula
    In Formulas and Functions
    Hi everyone! Hope you are all well and somewhat sane :) I need help with this formula and I'll explain the meaning: =COUNTIFS([Issuance Date]:[Issuance Date], <=MonthHelper$1, [Cardmember Status]:[Cardmember Status], "ACTIVE ACCOUN…
    Answered - Pending Review
    11 11
    Answered - Pending Review 11 views 11 comments Most recent by Paul Newcome