-
Is there a way to count a certain column based on the day of the week?
Is there a way to count a certain column based on the day of the week? what I want count the "Hold" (Yellow Box) in the Monday column if today is Monday or count the "Hold" (Yellow Box) in the Tuesday column if today is Tuesday..... continued for each day This is my current formula =COUNTIFS({Daily check Monday}, "hold" +…
-
Multiplication Formula
Hi, I have two columns 'Likelihood' and 'Current Maximum Impact'. All I want to do is multiply them together, can anyone help please? Thanks
-
Identify "youngest" date from "Created Date" Column
Hey Smart Heads, I have another question about our beloved topic of formulas. Background: I have a autogerated column with row created date. In the file, rows are added in 2 ways: In bulk, by senior auditor Ad-hock by auditor I would like to diferentiate these two types of inflow. I came up with an idea of finding…
-
Formulas
Hello I'm looking for Sum if formulas that meet my criteria Signed Cert is Yes and Total over/under budget is in black (positive) Signed Cert is Yes and Total over/under budget is in red (negative) (not shown in example below) Signed Cert is No and Total over/under budget is in red (negative)
-
Dynamic formula with multiple values connected by OR
I am using this formula in the green cell: =COUNTIFS({Product Development Backlog v1.0 - Status Column}, $Input@row, {Product Development Backlog v1.0 Initiative Column}, CONTAINS($[Output (Interpretation)]$2, @cell), {Product Development Backlog v1.0 Story}, CONTAINS([Output (Interpretation)]$14, @cell)) I would like to…
-
How do I use the attachment column in a Sheet Summary Formula?
I want to write a sheet summary formula that counts how many rows where the MoSCow column contains M, have attachments. The syntax I am using is COUNTIFS( range1, criterion1, [ range2,criterion2]). I have used this formula many times Getting the column criteria (range 1, criterion 1)specified is straight forward. But I…
-
Convert to Formula Greyed Out
I'm pretty new to Smartsheet and can't figure this out. When I right click ON THE CELL, the "Convert to Column Formula is greyed out" I am an admin I'm the owner of the sheet The formula does NOT contain specific cell references: =IF([Task/Project Type]@row = "Meeting: Once", "0", [Completed Date]@row - [Start/Started…
-
Formula for "Days since" event
Hi There, I'm looking for some help with a formula for a sheet summary field. I'd like the field to display the number of days since "today" that a checkbox was checked, based off the date entered in that checkbox's row. Example based off screenshot: "Today" is 12/4/2023. If the checkbox for Row 66 is checked the "Days…
-
Hi, i am trying to multiply number in column "Lineal Meters" by 3.2. What is the formula please?
-
Countif This Month, Next Month, Following Month
Heyo, I am trying to redo a formula to auto update with the information that I am currently pulling monthly for a dashboard. I am trying to sum the total fee installed if scheduled to complete this month, next month, and the following month. Here are the formulas I am using: This Month: =SUMIF({ECD}, IF(ISDATE(@cell),…