-
IF Statement Question
I am trying to get a formula to multiply [Sale Amount] by 12 if ERP is not JD Edwards, Microsoft AX, or Microsoft D365 OnPrem; otherwise, leave it blank... I have tried the following formulas (with their corresponding error messages). Is there an alternate formula I can use? 1) =IF(OR(ISINSET([ERP]@row, "JD Edwards",…
-
Trying to combine 2 formulas into one, each formula with multiple conditions
Hi All, I'm fairly new to formulas here on Smartsheet and have been racking my head over this one to no avail so far. I basically have two formulas that I am trying to combine into one, and each formula has multiple conditions. In the first formula, the conditions to be met are that if both columns of Date Received are not…
-
Today Function
I'm using the Today function to track weekly data counts. I'm wondering if there is a way to use the function to work backward from "Today" instead of forward?
-
Counting Blank Cells
I need assistance on counting all rows that are blank based upon a status column The formula I used is: =COUNTIF({Status Blank}, HAS(@cell, "--")). and I tried using this formula: =COUNTIF({Blank Status}), ISBLANK(@cell)) The "Status Blank" is referencing the other sheet.
-
I need help with creating a formula using Countif or Countifs.
I am trying to pull data from one range that has mulitiple values. Does anyone know how to write a formula to not pull information from more than one range? I am using the formula =countif(sheet reference data), (question ie: What do you enjoy most about your holiday party? @row. This works for when the question isn't set…
-
JOIN COLLECT if DATE Greater than
I would like to collect and display information as long as the date is greater than a specific date. Can I do something like this? =JOIN(COLLECT({activityname}, {name}, [Full Name]@row, {expensedate}, >=[Expense Date]$1), CHAR(10))
-
Is there a formula that allows me to cap a sum total?
I'm creating a database that allows me to track submissions and points associated with those submissions. Depending on the topic, there is a point cap associated with the submissions (i.e. you can exceed 300 pts for the year). Is there a formula that I can use that I can use that will help me cap these points? I use a…
-
Countifs w/ two date ranges and two different sheet
Hello All, I am trying to count the number of projects within the same date range, but there are two different sheets I need to pull this from. I keep getting an INCORRECT ARGUEMENT SET. Here's the idea of what I have: =COUNTIFS({Sheet1}, Criterion1 , {Sheet1 Date Range}, AND(@cell >= DATE(2023, 7, 1), @cell <= DATE(2023,…
-
Trying to trigger a flag to turn red once the project status column has changed
Have a Flag column named Outstanding Balance. I would like to have the flag trigger red if the project status column (which is a drop down) is changed to Invoiced or partial payment received. I have tried various formulas, but it keeps coming up with #unparseable. Any help would be appreciated. Thanks
-
Trying to Calculate a Date
I am trying to calculate a date between today and a static date like 10/20/2023. I cannot seem to get a result?