Using Contents from one Date cell to update another Date cell
Im trying to use a 'helper column' to run a formula that checks the contents of a date column/cell, and copies those contents to another date column/cell. The code I'm using is quite simple, so I feel that I must be making a silly error, or it is not possible.
To re-iterate, I have a cell specific date column , and I want to use a function in a helper column to change the contents of another cell IF the contents of the first column meet criteria.
even without logic, I cant find a way for a function to edit the contents of a cell without a function.
Is there something I'm missing, or is this outside of the capabilities of smartsheet?
Regards,
Frank
Answers
-
Can you share your formula and/or screenshots of the Sheet?
To clarify, your workflow is:
1) Date manually entered in "Date" column
2) Logical formula checks in "Helper Column" checks content of "Date"
3) Based on result of logic in "Helper Column," value in "Output Column" is changed.
If this is correct, the "Helper Column" and "Output Column" both need formulas, though it seems redundant and the "Helper Column" could simply display whatever value you need based on the logic.
School of Sheets (Smartsheet Partner)
If my answer helped please accept and react w/💡Insightful, ⬆️ Vote Up, ❤️Awesome!
-
Thanks for the Reply
Your summary of the desired workflow is correct.
I'm trying to keep The "output" column as a user-editable field. So I dont think a formula in that cell will work.
Maybe some combination of an IF/Match, but i'm not certain how to allow for a user selected value for the cell if a formula is used.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!