-
Conditional Formatting - multiple columns
Hi All, Hope you are all safe. Is it possible to apply conditional formatting to multiple columns (same condition). I have data in 10 columns. I want to highlight cells where the value is not equal to 0. Currently I have to apply conditional formatting to each column separately (cloning the rule). Is there a faster way?…
-
Formula Help
I have been trying to work on a formula within smartsheet and only part of the formula is working and I have been using AI through smartsheet. I need help with tha last 2 parts of this formula to get the date value to populate in the cell. The N/A portion works. Formula Description is used in AI is this =IF the [Kit Type]…
-
Formula based of portfolio report
Hi, I would like to do a simple count and countif based of my portfolio report. But when I start the formula and want to link to the report, it is not available for selection. I am the admin/owner of the report. Is it just not possible to use a portfolio file for formulas?
-
How can you count someone assigned to a cell if there are multiple people assigned in the same cell
Im using a metrics sheet to show home many people have RYGB symbols. However, there are some rows that have more that one person assigned to the task and it will not count their symbol if this is the case. Is there a formula that can count even if there is more than one person in the "ball in court" column?
-
COUNTIFS formula with several criteria not feeding into metrics correctly
We are trying to map out our issues that have been reported each month, with various criteria, and how many have been closed each month. I can see the data in my report, but i cant get it to feed over into my metrics sheet This is the formula that I am using: =COUNTIFS({Amadeus: TC Known Issues & Limitations Mas Range 2},…
-
Taking 1 Criteria and counting how often another occurs when Criteria 1 is met
I am trying to take if Canada (on a separate Smartsheet) is found, and if Africa is found (on a separate Smartsheet), count up how often it occurs This is the formula that I am using but i think its counting Canada on top of Africa =COUNTIFS({Graphical Behavior Analysis: 1S Graphical Range 1}, HAS(@cell, "Canada")) +…
-
Harvey balls formula
I'm trying to denote row status using harvey balls of 4 colors - red, yellow, orange and grey. Red - Blocked or end date is past Yellow - Start date is past AND status is not In Progress Green - End date is in the future Gray - Not started This is my formula - =IF(Status@row = "Not Started", "Gray", IF(OR(Status@row =…
-
Use IF Statement with Contact field
I have a workflow being sent to a user. Now this user may decide to delegate the task to someone else (by forwarding the workflow). Can I add an If statement to my workflow to see if the name in the Certified By is the same name as the TDL Project Manager? If they are the same, I want the workflow to be sent to ONLY the…
-
Formula to populate column with value from another column
Hello, I have a helper column (Project Title) that is supposed to populate with the Project Name based on the below formula. The AI indicates that the formula is supposed to locate the cell in the column "Action Items" that contains the term "Project Name" and then populates the "Project Title" column with whatever is…
-
Marking all tasks DONE by one click (several Levels of hierarchy)
We have project sheets with several levels of hierarchy items (parents, children, ancestors). I would like to have the option to mark all tasks DONE with one click to the highest hierarchy of a checkbox column. So far, I only found several solutions which would work on first level of indentation, but not lower levels. Is…