-
Date formula
I'm trying to write a column formula to give a response for a calendar difference. In one column I have a start date. In another column I have the end date, in a third column I have actual delivery date. I can write a formula that says if date 1 is > date 2 it would be "late". I can also write a formula for early, on time…
-
How to identify if a checkbox has ever been checked
Good morning, friends of Smartsheet, I need some help working through a process. I have a worksheet that has a checkbox column called 'escalate'. When we check that box, the row shows up on a report that our Compliance group can see, so they know their assistance is needed in some sort of communication efforts. Once the…
-
Unique Id in one sheet and Duplicates Id in another sheet
Hi Good people I have two sheets - FTTH Program sheet and the PMO_DataDump sheet On the FTTH Program sheet i have the unique id - PN number and on the PMO_DataDump also have the unique id with duplicates (PN Number), I'm trying to Calculate the sum from the column called HP from PMO_DataDump sheet for every unique Id in…
-
Countif help
Hey everyone. I see lots of countif when a column allows for multiple selections. But my column limits to only one selection. I assumed it would be the same calculation but I am not getting an answer. I am hoping you can help me work this through. =COUNTIF([Project Progress]:[Project Progress],(HAS(@cell, “In Progress - On…
-
How to create a formula column that calculates the difference between rows?
I have a sheet1 with columns labeled "Metric Name," "Plan-Actual," and monthly columns where we record the plan and actual numbers consecutively for the same metric name. Metric Name Plan - Actual Last FY - Jun Last FY - Jul Last FY - Jaug Test-01 Plan 90 89 21% Test-01 Actual 90 79 78 Test-02 Plan 90 100 120 Test-02…
-
Why didn't my original CountIF formula work?
I am trying to count the number of projects that began since Jan 1, 2024. I typed in the formula =COUNTIF([Start Date]:[Start Date], ">= Jan 1, 2024"). Basically I wanted to count the number of projects with a start date that were equal to Jan 1, 2024 or greater. However that formula gave the blatantly incorrect answer.…
-
Reoccurring Due Date Formula
Hi there, Is there a formula that would do the following: 1.) If Timeframe="Monthly" and Status ="Complete" then update Due Date to the same day next month. 2.) If Timeframe="Quarterly" and Status ="Complete" then update Due Date to the same day in 3 months. (Ex: if something is due 6/30/24 and is complete, then update due…
-
Why is 'DAY' Value from a Date being populated incorrectly?
I have a 'Formatted Date' column with a column formula (below) that formats the date from the row's date timestamp, which I renamed to 'Training Completion Date', into DD-MMM-YYYY format. All rows but one is getting the correct day from the DATE. I cannot figure out why 10/08/24 returns 9-Oct-2024. Curious to know if…
-
Counting items in a cell separated by comma
Hello, Thank you in advance. Need help getting the count of the values in a cell that are separated by a comma. Example in a Cell I could have three values: Blue, Green, Yellow. Need to return the value 3 but I can't seem to find that anywhere in the community. Thank you again!
-
Formula Help
Hello, I have a formula to determine the days between two cells: =IF(OR([Status]@row = "CLOSED", ISDATE([Closure Date]@row) = 1), [Closure Date]@row - [Date Initiated]@row, TODAY() - [Date Initiated]@row) However, I need to add in to return "N/A" to the days open if the value within Date Initiated is N/A. I have a similar…
