Smartsheet Basics
Smartsheet Basics
Ask questions about the core Smartsheet application: Sheets, Forms, Reports, Dashboards, and more.
Why sheet viewed - No action taken - but in Activity Log list Formatting Applied, Why?
Hi this can be mis read as action taken. WHEN ONLY SHEET VIEWED. Unless embedded formatting is doing itself (wild guess). Need to understand where/why this line of log came from.
Thanks, Jinwon
Best Answers
-
Hello @JinwonK,
Here is an example of conditional formatting I have setup on a sheet. The red box is the icon used to set it up. If you click on the icon, you can view any conditional formatting rules setup on your sheet. Is it possible this is what is showing up on your activity log?
Michelle Cullen
-
Your wild guess is accurate, as it turns out. :)
Essentially, certain things need to occur on a sheet in order for it to update. Among the list of things… a user must view the sheet.
Read from the bottom up, the log says:
"Jinwon opened this sheet. Cool. Cool. Oh - things have happened that didn't result in the conditional formatting updated. Since Jinwon opened this sheet like I just said… congrats, Jinwon - Smartsheet is crediting you with making all those conditional formatting updates. Huzzah!"If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
That number is basically how many changes occurred. In @mccullen's screenshot above, note that conditional formatting is set to update the entire row. I generally use conditional formatting on individual cells instead of the whole row - so I'm not sure if the number is how many ROWS, or how many CELLS. I haven't tested it. This is an interesting place for you to explore though - you can probably create a test sheet with very few columns, and apply multiple conditional format rules (some to entire rows and some to individual cells) and then futz with it and see what the results are. I've found that's the best way to answer a question in Smartsheet - jump in with both feet and just start playing. 😀
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
On this particular sheet, the conditional formatting is applied based on the Status. The status was changed twice, so the conditional formatting shows "Changed (2)".
Michelle Cullen
Answers
-
Hello @JinwonK,
Here is an example of conditional formatting I have setup on a sheet. The red box is the icon used to set it up. If you click on the icon, you can view any conditional formatting rules setup on your sheet. Is it possible this is what is showing up on your activity log?
Michelle Cullen
-
Your wild guess is accurate, as it turns out. :)
Essentially, certain things need to occur on a sheet in order for it to update. Among the list of things… a user must view the sheet.
Read from the bottom up, the log says:
"Jinwon opened this sheet. Cool. Cool. Oh - things have happened that didn't result in the conditional formatting updated. Since Jinwon opened this sheet like I just said… congrats, Jinwon - Smartsheet is crediting you with making all those conditional formatting updates. Huzzah!"If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
Thank you! The sheet does have conditional formatting.
One more Q: "Conditional Formatting Applied (12)," Do you happened to know what is the number 12 denote?
-
That number is basically how many changes occurred. In @mccullen's screenshot above, note that conditional formatting is set to update the entire row. I generally use conditional formatting on individual cells instead of the whole row - so I'm not sure if the number is how many ROWS, or how many CELLS. I haven't tested it. This is an interesting place for you to explore though - you can probably create a test sheet with very few columns, and apply multiple conditional format rules (some to entire rows and some to individual cells) and then futz with it and see what the results are. I've found that's the best way to answer a question in Smartsheet - jump in with both feet and just start playing. 😀
Good luck!
If this answer resolves your question, please help the Community by marking it as an accepted answer. I'd also be grateful for your response - "Insightful"or "Awesome" reactions are much appreciated. Thanks!
-
On this particular sheet, the conditional formatting is applied based on the Status. The status was changed twice, so the conditional formatting shows "Changed (2)".
Michelle Cullen
-
Hi Kerry, I believe you’ve demonstrated “Be generous” trait through SS Community Champion. THANK YOU.
I want to ask, convey Smartsheet for adding some sort of notation for the Activity Log when the log is generated by system. That denote the log resulted from user’s action or resulted of by system.
I think people overrate power of data – Dats show– Data says – like Data is G-d. Well, even G-d makes mistake!
I’ve been there. Wrongfully blamed of data output - Misperceived and misjudged. People give power to data without understanding where it came from. And often accused have NO leverage to prove otherwise.
I trust that you don’t mind me sharing a note that I saved a long time ago (Can’t remember where I got it) …. And it serves me as grounding reminder.
IF we are going to gather more data about our collective lives, we will also need to muster more compassion. What can you do to move us in the right direction?
- Be discreet. Resist the movement to document every aspect of your work or personal life. There are true advantages to preserving gray areas in which people can let their hair down and relax.
- Be human. Recognize that humanity is more important than the absolute truth. Use facts to help another improve his or her life, rather than to do something that might destroy their life.
- Be cautious. Recognize that the "truth" is always subjective. Each of us sees "facts" through a haze of beliefs, attitudes and experiences. No single test can judge the worth or potential of another human being.
- Be generous. Ask more of yourself. The best skill is bringing out talent in others, so rather than judging others, do your best to help them.
All the best, Jinwon
-
LOVE this!
IF we are going to gather more data about our collective lives, we will also need to muster more compassion. What can you do to move us in the right direction?Be discreet. Resist the movement to document every aspect of your work or personal life. There are true advantages to preserving gray areas in which people can let their hair down and relax.Be human.Recognize that humanity is more important than the absolute truth. Use facts to help another improve his or her life, rather than to do something that might destroy their life.Be cautious. Recognize that the "truth" is always subjective. Each of us sees "facts" through a haze of beliefs, attitudes and experiences. No single test can judge the worth or potential of another human being.Be generous. Ask more of yourself. The best skill is bringing out talent in others, so rather than judging others, do your best to help them.
Michelle Cullen
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.4K Get Help
- 465 Global Discussions
- 156 Industry Talk
- 510 Announcements
- 5.4K Ideas & Feature Requests
- 86 Brandfolder
- 156 Just for fun
- 81 Community Job Board
- 518 Show & Tell
- 35 Member Spotlight
- 3 SmartStories
- 307 Events
- 35 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- This discussion was created from comments split from: How to add logo in smartsheet Forms?.
- It seems as though the wrap feature is not working on the latest comment column. Trying to utilize this in a weekly WIP report and need the text to wrap to see the comment. See attached. I have 2 othe…
- Hi all, Our org has dozens of workspaces and while we have moved more toward group-based permissions recently, I still have some legacy workspaces that were configured with dozens of individual user a…
