-
Receiving error when using If/And
I have a sheet with the following columns, Date Opened, New - Review Date, Working Date, Alert column, and Status. New-Review and Working Dates are automated by the system when the Status changes to one of those options it records the date. I am trying to write a formula to fit the below scenarios: If one day has passed…
-
How to eliminate false counts on created date (auto-number deleted line items)
Hi there, Thanks for helping with this. I'm creating a sheet summary formula that does a count of items created within a specific year. All good there. =COUNTIFS([C-Year]:[C-Year], "2022") The wrinkle is that the sheet has autonumbering and so I'm getting a false count with 4 items that were created and then deleted. No…
-
Can a report automatically update (add rows) as the sheet behind the scenes is constantly adding cel
Can a report automatically update and add the rows that the sheet it is being used on? My sheet is constantly being added to and I would like the report to also add the cells when the cells are added in the sheet.
-
Calculating averages based on specific criteria per week.
I have a smartsheet that I am trying to find an average rating per week if there is specific criteria in a column. I've condensed the columns I'm trying to find an average of below The 'Created' column is an Auto-Number column for when the data is entered. I'd like to calculate the average, or 'Over All Rating' for each…
-
Floating dependency start dates
I have two dates: A and B. B's start is dependent on A's completion. If everything goes as planned, A will finish on 2/27 and B will start on 4/1. B's start date is constant unless A's finish is delayed beyond the planned start. For example, if A is delayed until 3/15, B will still start on 4/1; but if A is delayed until…
-
If it's blank, Red Symbol. If it's not blank, Green symbol.
I'm trying to get this formula to work correctly. =IF(NOT(ISBLANK([Link to ARP plan]@row)), "Yes", IF(ISBLANK([Link to ARP plan]@row)), "No")) It's not working. Any thoughts?
-
Using Contact List data in IF statement in Sheet Summary
I'm working on a system of sheets to track requisitions within our Talent Acquisition team. I've built out a helper sheet designed to help us track the average requisition priority ranking that each recruiter has. Since this is a helper sheet, its only purpose is to gather this metric, so I don't care what the sheet looks…
-
Nightly Automation with Today Formula
I seem to have a 'ghost' in my sheet where only half of my automated workflow seems to work on any given day. My sheet (called a playbook) has half of the rows with =Today() date formula, and the other half with a hard-coded date; each night at 11:00pm PST my worflow copies the Today rows to a 2nd sheet (called a tracker)…
-
Formula for automating Health status of project
I have two formula questions. 1. I have Parent rows with a rollup formula created that takes the avg of the RYG balls of its childreen and creates a status =IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow", IF(COUNTIF(CHILDREN(), "Green") > 0, "Green", "Gray"))) .... I also have a…
-
Switch Formula
Hello, I have recently integrated a project plan from MS plan to Smartsheet's however I can't seem to get the auto RAG Switch function working working as it was in Project Plan. This is the formula I used. Can anyone please help :) Switch( ([% Complete] = 100), "C", ([Baseline Finish] < Now()), "R", ([Finish] > [Baseline…