-
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,…
-
Count time between dates in Weeks/Days
How would I calculate the time between two dates (start and finish) in Weeks and Days "8weeks 4days"
-
Formula help = if date contains TBD, leave blank
Hello! I'm struggling with the 3rd part of my formula. I need to have the formula calculate: A date from the entered work week; be left blank if no work week is entered and leave blank if TBD is listed in the work week column 1 & 2 work using this formula: =IF(ISBLANK([Work Week]@row), "", (DATE(year@row, 1, 1) + 7 *…
-
Formula that updates Blank cells, ignores data when present
Hello everyone! Stumped trying to figure out a formula for our Pre Task Plan Smartsheet. We have a form submission process that users answer questions for their project. If they answer Yes, then they are asked to provide more information on 2 additional questions. However if they answer No, the other 2 questions are hidden…
-
VLookup with multiple references in one cell
Hey all, I'm not even sure what I'm after is possible, but thought I'd ask anyway. We're using a sheet to track users while they are out on test rides. Each model available for test rides has a number assigned to it. When users take a ride, we enter their name and the test ride ID# to identify who is on which (TRACKER). I…
