How to identify the first date and last date from another smartsheet column?
I need to identify the following:
Smartsheet 1, Column Start Date, row 1 cell 1 and Column End Date, row 1 cell 2 (need to obtain from smartsheet 2)
Smartsheet 2, Column Start Date and Column End Date have several dates. Smartsheet 1 needs to identify the earliest Start Date and the latest End Date from these two columns
Any help, I will appreciate very much! 😉
Rob
Thank you very much for any help!😉
Rob
Best Answer
-
You would replace the [Column Name]:[Column Name] with a cross sheet reference.
Answers
-
You can use a simple Max and Min type function if you are just looking for Latest and Earliest dates!
Example: = MAX([Column End Date]:[Column End Date]) will pull the latest end date.
-
but what is the formula to pull from another smartsheet?
Rob
Thank you very much for any help!😉
Rob
-
You would replace the [Column Name]:[Column Name] with a cross sheet reference.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.6K Get Help
- 435 Global Discussions
- 152 Industry Talk
- 495 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 508 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 308 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!
Trending in Formulas and Functions
- I am working in a separate sheet for calculating metrics. I want to count the number of items in a referenced date range in another sheet that meet certain year criteria. For example, I want to find t…
- I have a column that is a contact list where a single or multiple staff members can be selected to be scheduled. I'm trying to create a formula that counts how many times each individual's names are l…
- I have two columns I am using for this formula: "Date Received" and "Days Duration (Received to Listed)". I want the formula below to look at any items in the Date Received column between 1/1/25 and 1…