-
IF(AND(DATE(YEAR
Hi Team, If(and( this MONTH/YEAR date matches the [Comms Due Date]2 MONTH/YEAR date then return 2% of [Current Month Sales]2 dollar value or nothing. (Text number cell) =IF(AND(DATE(YEAR([Comms Due Date]2), MONTH([Comms Due Date]2), ([Current Month Sales]2,*2,''-"))))
-
Setting a conditional format when a date is e.g more than a week ago??
Hello all I am fairly new to Smartsheet and am trying to create an 'orders overview & management spreadsheet' for our family business. I want apply a conditional format to a particular date column so that if the date entered is more than 7 days ago, it will highlight the cell in red & bold. I can't seem to do this with the…
-
Sum rows that are not children
I am creating a SS that contains a row for each event and below children for event expenses. The top/parent row calculates the sum of the children beneath it. I would like to create a Totals row that calculates the sum of all the top/parent rows. Is this something SS does?
-
Help with IF/AND formula
Hi--I've been reviewing sample Smartsheet formulas from discussions past, but can't quite get my (relatively simple) formula to work. I'm trying to return a checkbox for a given row (let's say 1) if "Rehab?" column is "Yes" AND "Xtra Cost (cog, rehab, tx, etc.) is blank. I've tried several different formulas, but most…
-
Multiply total project cost by percentage to get sale price
Hello! This is my first post, and I know the answer is simple, but here it goes: I want to take a total project cost column and multiply it by a percentage that is inputted into another call, and have the answer populate an "Extended Price" column. Eventually I want to be able to add subtotals and do the same thing, but…
-
Mixing overwrite with formula
Hi-- so, I have a wonderful formula in a cell whereby depending on the dropdown choice selected in another cell, X, Z, Y occurs in the cell where the formula resides. What concerns me is that sometimes a situation may occur where overwriting that formula is temporarily necessary. But we don't want to lose the formula there…
-
Formulas Usability Study
Hello Smartsheet Community! We're conducting a usability study for formula enhancements in Smartsheet and we'd love your participation! Head over to Daniel Stein's discussion and use the Sign Up Link to get started.
-
Selecting the Next Task
This is a bit of a weird question but I'm trying to figure out how to make SmartSheet inform me what my next milestone is for a project. Basically I have a series of projects (say 40 or so) that each have their own project schedules. In those schedules, some tasks are marked with a checkbox to indicate they are critical…
-
Need help on Summing Values based on drop down menu that contains text options
Hi, I have a question regarding using formulas and drop down menus. Similar to an FMEA, I want to have dropdown menus (High, Med, Low) for the severity, occurrance and detectibility. Then I want to have a formula that produeces a RPN (Risk Priority Number) by assigning the value 10 to High, 7 to Med and 3 to Low and…
-
IF/AND Formula
Hi, I am following identical logic to another formula in my sheet that is working, so I cannot for the life of me figure out why this is not: =IF(AND(Eval Payment Status]1 = "Appointment Pending (pay plan)", [Initial Pay Plan Amount Due]1 = 0), 1, 0) Here, I am trying to establish that IF Eval Payment Status shows…
