-
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…
-
IF Function
Hi, I want a formula to report if the Actual Start date is greater than the Baseline start then put the tick and cross symbol. The formula works however even when there is no actual start date entered it will still populate. I need a condition for if it is blank then no symbol appears. Can anyone please help me out? :)…
-
We have products with expiration dates and we need a cell to count them in a range of days.
We have a column with expiration date that is put in manually by an employee with the rest of the data when received. Currently we have conditional formatting to highlight the products expiring within 30 days via the row turning yellow. We need a cell that will automatically count and display a value for all yellow…