-
What is the best way to pull data for the current year from another sheet?
I have a sheet that pulls monthly data for items corrected and not corrected. The formula I use works great, but I only want data in the corrected column to use current year data. Here is the current formula: =countifs({Hospital Month Corrected}, "3", {Hospital DateCreated Corrected}, Month(@cell)=3) This gives me the…
-
Looking for formula to look for partial match in other columns, returning contents of a column
I am hoping to to get some help with a formula that would look for a partial match in one column when compared with another, returning the contents of a different column in the same row. Column 1 name: Current Process stage Column 2 name: Current process Stage status Column 3 name: S1 Conduct Deep Dive Status Current…
-
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]…
-
How to set up schedule health for my project plan in Smartsheet?
Hello! I started using Smartsheet for project management and I'm having a hard time setting up schedule health. It is a bit time-sensitive as well. This is what I need: I need some sort of formula that will automatically show schedule health based on the completion or non-completion of a task, using the Start Date, End…
-
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?
-
Help with Formula
I have the following formula that returns as incorrect syntax and I can't seem to resolve it: =IF(AND([Actual Completion Date]@row "", IF([Estimated Completion Date]@row = "", "", IF([Estimated Completion Date]@row <= TODAY(+5), "Red", IF([Estimated Completion Date]@row <= TODAY(+14), "Yellow", IF([Estimated Completion…
-
Countifs contains
Trying to count if a cell by criteria if another cell contains "device": =COUNTIFS(CONTAINS("Device", [eCOA Department]:[eCOA Department]), [Award Date]:[Award Date], >=DATE(Year#, 3, 1), [Award Date]:[Award Date], <=DATE(Year#, 3, 31)) #INVALID OPERATION
-
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?
-
=IF (multiple criterion) then mark as "Yes"
I am trying to make a cell read "Yes' or "No" based on criterion from another sheet. Basically, if all projects under a certain package have set schedules then the cell should read "Yes" and vice versa "No". The issue is that there are some parameters needed to determine if a project is under a certain package. A Project…
-
How can I convert a referenced created date to a numeric value in order to calculate time lapsed
I reference two created date fields from another sheet. I use the following formula to reference the created date: =IFERROR(INDEX({2a. FEMALE CHANGE ROOM Range 1}, MATCH(JOIN@row, {2a. FEMALE CHANGE ROOM Range 2}, 0))+ "", "") The result is displayed as 10/01/25 10:35 PM which is correct. My problem: I need to calculate…