Date Formula For Master Sheet
![BESP10](https://us.v-cdn.net/6031209/uploads/defaultavatar/nWRMFRX6I99I6.jpg)
Good afternoon,
Per attached how would I set a formula up for the date in "Needed On Site" column to equal the date in the "End Date" delivery column
Thanks
Answers
-
Have you tried...
=[End Date]@row
?
-
Yes I did , thank you .
What we are doing is creating a report for our shop manager so he knows the date that the product needs to leave our facility. The =[End Date]@row is returning for that specific row. We need to be able to return the date for when the product is shipping which is the row below so that we can show it in a report without him having to visit the master sheet
-
Oh. Then you should be able to change "@row" to the corresponding row number.
-
Would I have to do it for each instance or can this be a column formula? @Paul Newcome
and thank you
-
It would have to be for each instance.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!