-
At Risk formula include when Status is <blank>
Getting started in Smartsheets for Project Management. I've been reading a number of Q/A on creating formulas to flag At Risk. I want to flag any task 3 days before the End Date or if it's past the End Date. Additionally, flagging any task where the Status is NOT Complete. Here is what I've been using so far: =IF([End…
-
How to create a top 5 list without duplicate values
Hey there, I am trying to create a top 5 list of values from a large table of information. the idea is that you would be able to see which "ATA Chapters" have the highest figure next to them, for example if you look at the attached image "ATA 25 - Equipment & Furnishings" has a total of 5 in its row if you add the numbers…
-
Index/Match situation.
Hi, I apologize in advance, but I've been searching, and trying to figure out how to do this, and I guess I am just not understanding things (or it's not possible). I have 2 sheets. One is a checklist for all new stores. The other is a checklist for the IT installation of stores for a particular week (though I'm not sure I…
-
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…
