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 FormulaIn Formulas and FunctionsHere 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 …
-
SUMIFS with 2 FactorsIn Formulas and FunctionsI 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 😑
-
Moved: Is there any way to make a task start and finish according to another task?In Formulas and FunctionsThis discussion has been moved.
-
Moved: Report with What and When requirementsIn Formulas and FunctionsThis discussion has been moved.
-
Report with What and When requirementsIn Formulas and FunctionsHello 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…
-
Help with a formulaIn Formulas and FunctionsI 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…
-
Moved: Add data to existing sheet from mobileIn Formulas and FunctionsThis discussion has been moved.
-
Moved: Automatically Populate Status - Sales PipelineIn Formulas and FunctionsThis discussion has been moved.
-
COUNTING MTD ENTRIESIn Formulas and FunctionsI 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
-
Help with a Monster FormulaIn Formulas and FunctionsHi 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…