-
If statements with currency positive and negative and needing value
I'm having to try to create several formulas so that I can in turn create triggers. I need to say if there is a value in cell A with a difference of $1 (positive or negative) from cell A and cell B I want it to say notify, if not say no. Anyone have a suggestion. I had =IF([Cash Distribution (AM)]@row - [Received Cash…
-
Health Icon Formula Help
Hi All - Longtime lurker, first time poster. I am attempting to add a Health Column to a smartsheet created by a colleague. I have been in the forums checking answers to similar, and tried to kluge my own formula together, but I've either missed the logic or I'm trying to do too much. What i'm trying to achieve rollup…
-
Move child row under new parent row when a cell value is changed.
I have parent rows (upcoming week, current week, and past weeks) and I'd like to be able to change the status cell from upcoming week to current week, and have it move the row under a different parent row. Is this possible?
-
How do I copy the info from the cell above if criteria are met in another column?
What I would like to do is create a formula that will copy the information in the cell above it if the 'X-code Details' is chosen in the pick list in the column next to it. If General Run Details is indicated, want the entry to remain. I know there has got to be an easy solution to this, I just can't find it and AI is not…
-
Help on formula: count if with multiple criteria
Hi all, I'm trying to get the count of active projects in my tracker sheet however I'm getting zero as a result. Please, can you check and advise what should be the correct formula? Here's the formula I used: =COUNTIFS(Stage:Stage, "planning", Stage:Stage, "strategy", Stage:Stage, "tender", Stage:Stage, "evaluation",…
-
COUNTIFS question
EDIT - I think I solved my original problem by removing the <> before the "2099". However, how do I write the formula to show not equal to 2099 without using an operator? SS doesn't seem to like it when I use <>. ******Hi, I've browsed a number of the COUNTIFS posts but for some reason, I can't get my formula to work. It…
-
VLOOKUP No Longer works with same formula
This worked right before New Year's. Now for some reason it says Incorrect Argument Set?=VLOOKUP(Email@row, {RRFP Sales Log 2025 Total Cost}, 13, false) Basically I have the clients' email in the Primary Column for Smarthseet 1 and 2. I sheet 2 is RRFP Sales Log 2025 and Total Cost is the name of Column I need pulled from…
-
Percent formula for drop down fields
I have a column with the following options for drop down fields: NA, Not Started, Required, Drafted, Posted What formula can I use to show me % complete (posted) without taking into account the NAs?
-
New! TIME function for formulas
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…
-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…