-
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),…
-
=IF(CONTAINS 2 Red Harvey balls they status changes to "red".
Hello! It's me again, Is it possible to have a formula that the Harvey Ball in "Overall Status" changes depending on the other 4 rows? IF I have 4 Green Harvey Balls the "Overall Status" is GREEN IF I have 3 Green Harvey Balls the "Overall Status" is YELLOW IF I have 2 Green Harvey Balls the "Overall Status" is RED I have…