-
COUNTM formula with IF COUNTM Formula
Help, I've tried multiple formulas mentioned in various question strings and nothing seems to work. (Preface: I haven't used formulas in quite a while). I have a sheet with two different drop down columns that I need to reference in the formula to get a count based on certain criteria. In the end I want to count the number…
-
Counting Unique and First Values Using MIN / COLLECT
@Paul Newcome - I tried using a solution you recommended on another thread for counting the truly unique and first-instance-of-duplicate values in a column, and I've hit a wall - could use your help (or anyone else who is way smarter at formulas than I am ...) [Row ID] = Auto-number [Lookup Index] = Join of [Product…
-
How to change the title of a sheet in the report calendar view?
I have a report set to calendar view with numerous sheets feeding it and due dates tied to them. The title for the bubble that shows up on the calendar view defaults to the name of the sheet. I want to be able to change the title to a cell within the sheet, is this possible?
-
CountIfs Question
Hi all, I have a formula where I am essentially counting the number of responses by specific criteria. I have it working with the exception of when multiple values are selected from the drop down. I have posted photos below. I am trying to have it count for all of the areas of concern. For example, the Challenger would…
-
Determination of Request Type based on form answers
Hello all, my org handles a few types of requests that are broken out based on need and qualifications. I am attempting an integrated request form that will remove the need for multiple form types. I am wanting a column [RequestType] formula to come up with results based on the answers in the form. One thing that may…
-
Count of rows created on 2 sheets within a certain time frame.
Hi everyone! I would like to get the count of rows created on 2 sheets within a certain time frame. I created a formula (1) to get the count of one sheet and it worked. I tried to add the other sheet to the formula (2) but I got an error message (3). =COUNTIFS({Created 2}, IFERROR(MONTH(@cell), 0) = 5, {Created 2},…
-
Subtract 2 Months from "6 Month Renewal Reminder" Date Column
Hello, What formula reliably returns a date 2 months before the date in the "6 Month Renewal Reminder" date column? This is the last formula I tried, which I found in another article here in the Smartsheet Community. =IF(MONTH([Date Column]@row) - [Number of months before]@row <= 0, DATE(YEAR([Date Column]@row) - 1, 12 +…
-
I need to add days to a date with a formula.
I use the formula: =Procedure8+35 and it will calculate 35 days from procedure with the correct date. If I ask it for +76 days I will get #INVALID COLUMN VALUE. Not sure what I am missing. Procedure is the column and 8 is the row where the date is calculated from.
-
#INVALID VALUE from =INDEX formula
I have this formula, that works in other sheets that I have, however in this one it returns the #INVALID VALUE error. Help? =INDEX([Current Task]3:[Weekly Status Notes]86, MATCH(true, [Current Task]3:[Current Task]86, 22)
-
Project Status to Update a Sheet Summary Status - Formula?
Is there a way to have a formula in a row or in the sheet summary that does the following: When a row is added in one sheet and the project status is Completed, then within the project itself in Sheet Summary change the status to Completed as well? I am not sure if it is possible as one status in one sheet would have to…