Pull Last Entry from One Sheet to Another Based on Criteria

Answers

Paul Newcome ✭✭✭✭✭✭

04/19/21

A quick tip for the reverse...

Flip where the form populates, enter a system generated created date column, sort in reverse order based on this column, then delete the column.

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter
Jonna Critchley ✭✭✭

04/19/21

@Paul Newcome glad i read this first!!

0 · Share on Facebook Share on Twitter
Jonna Critchley ✭✭✭

04/19/21

@Paul Newcome BINGO! Thank you for your assistance sir!

0 · Share on Facebook Share on Twitter
Paul Newcome ✭✭✭✭✭✭

04/19/21

Happy to help. 👍️

CERTIFIED SMARTSHEET PLATINUM PARTNER
10xViz.com
0 · Share on Facebook Share on Twitter

Help Article Resources

Create and edit formulas in Smartsheet

Formula combinations for cross sheet references

Smartsheet functions list

Categories

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions

How to calculate NPS Score from Smartsheet Sheet
Hello, I have tried to calculate our NPS score, but am getting either UNPARSEABLE or 0. What am I doing wrong here? I've tried this formula (NPS Score 1): And this one (NPS Score 2):
Identifying oldest entry on sheet, for different groups
Hello! I am working on a "waitlist" process, where the sheet will have multiple candidates under each work location. I need a formula to identify the oldest entry for each location, and if there are multiple entries for the earliest date, use a "score" column identify the higher score as the next candidate in line. Example…
Week Over Week Change
I have a sheet that has orders entries from the last 6 months. This sheet continues to populate as more orders are made. This is just my repository sheet. I am looking to get the week over week change metrics for the last 7 days. Here's the formula that can provide me that week over week change: Week over week %% =…