Formulas

I am trying to make a sheet summary that will give me the average of column "# of Days Open" if column "Date Entered" is equal to the last 180 days.

the first screenshot below is picking up the month number the stage is against the project name (primary column) pls scroll down the second screen shot below is my set up to try do a count function against month numbers I am failing to get the correct count function for this sheet im trying to make it dynamic rather than…

Hi all, Trying to use a formula to work out net days between events in a column (Visit End Date) when a second column (Visit Description) contains "V" but also only if the last visit also contains a V. =IF(CONTAINS("MV", [Monitor Visit Description]@row), NETDAYS([Monitor Visit End Date]1, [Monitor Visit End Date]2)) worked…

Hi all, I was wondering if anyone can help me and apologies if I do not explain this very well. I am trying to make an addition to an existing formula, to exclude a value from another sheet, but still count blanks. Current formula under 'Total Perm' column on main sheet: =IF(OR([Perm Promo]@row = "No available promo", [Max…

I need help to edit this formula to include only Designations with a Date of Manufacture (this is the column name) greater than 01Jan2025. I keep getting a request to regenerate the question. =COUNTIFS([Days btw Capping & Mfr Release]:[Days btw Capping & Mfr Release], >60, Designation:Designation, <>"PPQ1",…

We are setting up a raffle where we will send out a form for someone to completed to enter the raffle. Once submitted we will take the (Full Name) column and randomly select a winner. We do have a few things on this sheet, we check to make sure there are no duplicates on the sheet, and once a winner is selected and checked…

Hello, I have a column "OPRO #" where it lists hundreds of OPRO # with many repeating number. I want to pull the unique numbers and list those in a separate column where each unique number has its own row. I am having issues finding a working formula. Thank you in advance for the help!

Hi, I have a complex formula that i cant seem to figure out. I'll do my best to describe this below In Sheet 1 i have a unique identifier whose condition changes from blue to green after a certain date Unique identifier Condition StartDate EndDate 123456 Blue 1/5/2025 31/10/2025 123456 Green 1/11/2025 I want to ensure that…

I'm working in Smartsheet Gov, which has several limitations that don’t apply in commercial Smartsheet (ex: no Manage References, no HAS(), no FIND() in COLLECT, and very strict parser rules). I’m trying to build a “Calendar Conflict” flag in my Project Plan sheet that detects when: A task’s Start/End dates overlap with a…

Currently, sorting in Table View only impacts how data is displayed. It does not actually change the order of the underlying data. There are times where I rely on the data to be in a specific order (not just displayed). Lets say I have a project plan. There is a requirement that my child rows are numbered in chronological…