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 …

  Susan Swisher

  04/10/20

  Accepted

  23 12

  Answered ✓ 23 views 12 comments 0 points Most recent by Paul Newcome 04/10/20
• 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 😑

  Susan Swisher

  04/10/20

  Accepted

  11 8

  Answered ✓ 11 views 8 comments 0 points Most recent by Paul Newcome 04/10/20
• 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.

  Alejandra

  04/10/20

  1 0

  Closed 1 view 0 comments 0 points Started by Alejandra 04/10/20
• Moved: Report with What and When requirements

  In Formulas and Functions

  This discussion has been moved.

  Alejandra

  04/10/20

  1 0

  Closed 1 view 0 comments 0 points Started by Alejandra 04/10/20
• 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…

  Elisabeth

  04/10/20

  73 10

  73 views 10 comments 0 points Most recent by Paul Newcome 04/10/20
• 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…

  Mark McLean

  04/10/20

  Answered - Pending Review

  11 4

  Answered - Pending Review 11 views 4 comments 0 points Most recent by Paul Newcome 04/10/20
• Moved: Add data to existing sheet from mobile

  In Formulas and Functions

  This discussion has been moved.

  Alejandra

  04/10/20

  1 0

  Closed 1 view 0 comments 0 points Started by Alejandra 04/10/20
• Moved: Automatically Populate Status - Sales Pipeline

  In Formulas and Functions

  This discussion has been moved.

  Alejandra

  04/10/20

  1 0

  Closed 1 view 0 comments 0 points Started by Alejandra 04/10/20
• 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

  Jason Egles

  04/10/20

  Accepted

  65 9

  Answered ✓ 65 views 9 comments 0 points Most recent by Paul Newcome 04/10/20
• 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…

  Darla Brown

  04/10/20

  Answered - Pending Review

  11 11

  Answered - Pending Review 11 views 11 comments 0 points Most recent by Paul Newcome 04/10/20