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.
Conditional Formatting Do not modify current value if condition in other field fails
Without creating another column, I am trying to update a current value only if the condition is met in my modified by field. My formula (below) works when the condition is met.
How do I tell SS to leave the current value as is if the condition is not met?
=IF([Modified By]1 = Owner1, " ", Modified1)
Background: Above formula is going in my 'Last Updated' (date) column, which controls 'Update Status' column by changing RYGB symbol according to today's date and 'Last Updated' date.
Multiple people can update the row in the sheet, so I only want RYGB to change when the user making changes matches Owner, Assigned To #1, or Assigned To #2. (Note: I haven't even started to incorporate whether IF Modified by = Assigned To #1 or #2 or both). Ugh.
If any can point me in the right direction, I would appreciate your help.
Sandy
Comments
-
Sandy,
Within Smartsheet, you can't. There is no way to toggle a formula off and "lock in" the results.
For small projects, I use Zapier to lock in a date based on another condition.
See the post for details on that.
http://ronin-global.com/2016/12/11/smartsheet-fixed-date-upon-completion/
Craig
-
Craig:
Okay. Thank you for your input.
Sandy
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 68 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives