Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Formula to change date based on adjacent drop down menu
I'm trying to set up a tool inventory, to help keep track of the location of all our big ticket items.
I've created a row for each tool. Asides from various descriptive colums, I have one column set as a drop down list (listing the numerous job sites the tool might be pulled to). I also have a Date Pulled column, to show when the tool was moved.
I want the "date" column to automatically populate to "today's" date whenever the drop down menu changes (regardless of what it changes to).
Any suggestions on a formula? I'm fairly clueless to smartsheet formulas and functions beyond the basics.
Cheers
Comments
-
Hi Grant,
If I understand what you want, you could use a formula along the lines of the following one in your "Date Pulled" column:
=IF(ISBLANK(Location1), "", TODAY())
Also good to keep in mind things like Cell History, which can tell you when and who changed the "tool location" value.
Hope this helps.
Scott
-
Hey Scott,
Thanks for the suggestion.
I gave that a shot, but realized I would need to change the numerical location # for each row. Also, the "location" would never be blank, but either at our shop or job site. But that didn't seem to affect the formula for how I used it.
For now, I'm just using a date system column which auto populates the date modified. A little clunky but I will see how it pans out.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.6K Get Help
- 403 Global Discussions
- 215 Industry Talk
- 455 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 56 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 296 Events
- 36 Webinars
- 7.3K Forum Archives