-
average progress depends on criteria and vlookup
Hello all, we are trying the following: In a new sheet we want to reproduce some information from the source file using the VLOOKUP function. So far so good. Now the question is, if there is a formula, which from the Children lines outputs the average progress, where the lead is called "Kunde". There can be several lines…
-
How to select value from last column in a range
Hi! Would love to get feedback on how to create a "Current Status" formula that looks by row across columns to pull the latest value. What I want is a formula that updates automatically as I populate columns with weekly Account Status. Below is a screenshot that shows the columns I am working with. The leftmost column is…
-
Automation of Status Drop Down at the Parent Level
Hi, I want to automate the status column of the parent row based on the child rows. For example, if all of the child rows are left blank or marked "Not Started," I want the parent row to read, "Not Started" Or if a majority of the child rows are marked "In Progress" and some are marked "Complete" I'd like the parent row to…
-
Formula for Health based on Week
Hi everyone - I have a Project Plan with an associated Master Tracker & Metrics Sheet. I am wanting to pull in the Health (RYG symbol column) based on the week. An example of my Project Plan is below: You'll notice I have a "Week (Helper Column)" which helps me with calculating which week a project is at any given time.…
-
How to Auto Delete Duplicate Entries based on a User ID and Date?
Hello there, I am new to Smartsheet and trying to figure out how to build a formula to delete duplicate entries based on the "E number" and the "Content for the Week of". This sheet will be tracking form submissions and I want to delete any duplicate submissions by an individual for a given week. The screenshot attached…
-
Percentage Increase/Decrease
Hi there, I've looked at some other answers in the community but none seem to work for me. I'm trying to determine the % increase or decrease of values Year Over Year. Here's an example: THIS YEAR, we have a sheet that shows $125,000 in revenue. This time last year on a separate sheet, we showed $225,000. How do I create a…
-
RIGHT + FIND with LEFT + FIND
Hi, So I can run automations to notify individuals, I have a column that is a contact list. For data reporting purposes, I need to upload the names into an API in a (last_name, first_name) format. To get around this, I have concocted a two-step process: Write a function in a cell to pull back (first_name last_name) Write…
-
VLookup Issues
Problem: While I am able to input the VLOOKUP formula correctly, I having an issue with it returning correct data. I am using a form to track attendance. The same form inputs dates from different lab types but creates a row with each entry. Each different lab date creates a new row as designed. I am trying to move the data…
-
Nested IF statement with VLookup Formula
Hello, I have two sheets that contain data from employee responses to different questions. Employees answer at least one question per day. If an employee answers the question on sheet 1, I need that value, if they dont have a response on that sheet, I need to look and see if there is an answer is on a different sheet. I…
-
Estimate Date Planned against the target date
I need to calculate the planned date against the Go-Live date for each column. The dates are above the columns that should be prior to the Go-Live Target which is 10/31/22. I need to make the actual columns cells yellow for 3 dates against the planned date, red at the planned date. If a date is entered in actual column,…