-
CONTAINS COUNTIFS from Multi-Select Drop-Down
Hello, I've had this issue before, but forget how I've solved it. I have a formula that is trying to count an option in a multi-select menu, it cannot be a simply COUNTIFS statement and must use CONTAINS or HAS since there is more text in the cell then just one word. Here is my formula, which is appears the syntax is…
-
Should be simple CountIF
Any help on why this isn't working would be great.
-
Formula to auto-number rows for multiple projects within a single sheet
Hello, I'm looking to a formula that will auto-number rows for multiple projects within a single sheet. For example, I have rows for Project A, Project B, and Project C in the same sheet: Project A Project A Project A Project B Project B Project B Project B Project C Project C I want my auto-number column to return the…
-
PI formula
I need to reference PI for circle maths. a PI() function or a universal variable would be very useful and I'm frankly shocked it doesn't exist already. It'd function exactly like TODAY() but a number instead of a date.
-
SUMIFS with OR function (multiple criteria in same column)
Hello, I am trying to get a sum if the criterion in a certain column meets one of several conditions. If the country code equals one of the country codes in the "country" column, I would like to sum the Total MVE for each country code. Right now I have" =SUMIFS([Total MVE]1:[Total MVE]66, Country1:Country66, ="AU",…
-
Adding the number pi (π)
I'm using a sheet that needs to calculate things using circles and therefore requires the use of the number pi (π). Is there a way to express π in Smartsheet without typing it out to the full default sigfigs? 'Cause I'd rather not do that, even in sheet summary. While we're at it I'd quite like the number e as well, but…
-
Formula to add two separate columns with MONTH and YEAR criteria (blank dates too)
The formula below for March works for rows where [Date Recd] and [DateCompleted] both have dates; however, it errors out when [DateCompleted] is blank. How do I update the formula below to also sum [Received Count] where [DateCompleted] is blank and [Date Recd]'s Year = 2022 and Month = 3? Need the formula below to add…
-
Record a date & Time
Greetings, I have a workflow that requires multiple approvals as well as recording the date each approval status was made. How do I also capture the time of approval as well as the recorded date?
-
Health Status Formula RYGG
Hello, I am new to smartsheets and I am having difficulties setting up basic Health Formula with RYG+Gray bullets based on Status (Cancelled, Delivered) and Due date column. GRAY when Status is Cancelled RED when Status is Delivered, but after Due date GREEN when Status is Delivered till and on Due date YELLOW when none of…
-
Nested AND/OR statement with COUNTIF
Hello, I'm trying to count the number of rows that fit this criteria: This is the formula I came up with but am getting an error. I'm betting that the problem is the placement of the ANDs? =COUNTIF(AND((OR({Retail Survey Launch Status} = "Operational", {Data Upload Status} = "Operational",(AND({Experiencia Rounding…
