-
IF/AND for date range and TODAY help
I'm looking to return phase names based on if today's date falls within specific time ranges on another smartsheet. For example: I have start and end columns/dates on one sheet for "Phase 1," "Phase 2," and "Phase 3" for different projects. On another sheet, I'd like to return "Phase 1," "Phase 2," or "Phase 3" if TODAY…
-
Summing a Multi-Select
I'm trying to figure out an easy/dynamic way to sum a column. Right now, I have Column A in Sheet 1 that is a multi-select. I want to lookup the result of that multi-select in Sheet 2, and total the values from Column B. So I know how to do it manually (i.e. - by spelling out all the values using FIND () or HAS ()) as part…
-
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…