Pull latest date of a task from a Task Sheet to a Latest Contacted Sheet
Hi community!
I'm trying to find a way to have two sheets linked together.
1st Sheet: "Task Dump" where I can input the day-to-day tasks & notes after chatting with customers.
Columns: Customer Name | Date | Type of Task | Action Items | Addtl. Notes
2nd Sheet: Pulls in the latest contacted date, type of task, action items, and notes into 4 columns of a much larger list.
The goal is to be able to view a dashboard where I can pull in all the tasks had with a specific customer, items pending, and a bunch of other details from the 2nd Sheet.
Have any formulas worked for you? I've been able to create this in gsheets using the below but have not had success with it here.
IFERROR(VLOOKUP(SORTN(SORT)))
Answers
-
How are you inputting data into the first sheet?
Have you looked into creating a report? You can insert a system generated Created (date) type column on sheet 1, filter your report by client, then sort by created date (descending) so the most recent is on top. If you include a "completed" checkbox on the first sheet, you could also filter the report to show only rows for that client that are not completed.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 142 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!