Published User issue
The Activity Log properly logs the system users and their activities. What shows is the user's name and the activity info.
I notice however, that several entries in the log lists "Publised User" as the person whose acivity is tracked.
How do I tell who this "published user" is, and why isn't the user's nme listed instead?
Comments
-
J. Craig Williams ✭✭✭✭✭✭
The Published User should be coming from a generic link that does not require a login. There is no way for the system to know who that might be.
Craig
-
SALJ ✭
Curious to learn why there is no way to identify who is accessing the shared pages. My thoughts are that web analytics should provide insight to whom in the world is access the sheets/pages.
Eager to find a solution.
-
I would also like to find a solution. Our firm is phasing our Excel and merging to Smartsheet for some tracking. The issue is: Some firms are prohibited by their IT department from clicking on private links. They are allowed to open public links, so the publish option "sort of" works. But, then we can't see who is making changes.
Perhaps Smartsheet can implement an option for public users to sign in, or at least "name" themselves while viewing the published sheet.
A solution to this will be much appreciated and encourage our firm to use Smartsheet more.
Categories
Perfect. Thank you so much!<\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":343,"name":"Add Ons and Integrations","url":"https:\/\/community.smartsheet.com\/categories\/apps-and-integrations","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]},{"discussionID":106962,"type":"question","name":"Issue with cross-sheet =INDEX(MATCH()) formulas","excerpt":"I am consistently coming across an error where my cross-sheet referenced =INDEX(MATCH()) formulas are pulling the incorrect information. I am fairly certain my syntax is correct and that this is a bug. This is happening across multiple sheets I have. I have included one example, but note that I have found this to happen…","snippet":"I am consistently coming across an error where my cross-sheet referenced =INDEX(MATCH()) formulas are pulling the incorrect information. I am fairly certain my syntax is correct…","categoryID":321,"dateInserted":"2023-06-27T15:24:54+00:00","dateUpdated":null,"dateLastComment":"2023-06-28T13:34:44+00:00","insertUserID":162821,"insertUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"updateUserID":null,"lastUserID":162821,"lastUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":5,"countViews":56,"score":null,"hot":3375841778,"url":"https:\/\/community.smartsheet.com\/discussion\/106962\/issue-with-cross-sheet-index-match-formulas","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/106962\/issue-with-cross-sheet-index-match-formulas","format":"Rich","lastPost":{"discussionID":106962,"commentID":382828,"name":"Re: Issue with cross-sheet =INDEX(MATCH()) formulas","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/382828#Comment_382828","dateInserted":"2023-06-28T13:34:44+00:00","insertUserID":162821,"insertUser":{"userID":162821,"name":"egardner","title":"IT Project Coordinator","url":"https:\/\/community.smartsheet.com\/profile\/egardner","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/userpics\/4VRPFNVQ0MWG\/n8WTXSBZQZI0N.JPG","dateLastActive":"2023-06-28T13:32:15+00:00","banned":0,"punished":0,"private":false,"label":"✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Using Smartsheet","url":"https:\/\/community.smartsheet.com\/categories\/using-smartsheet"},{"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B"}],"groupID":null,"statusID":3,"image":{"url":"https:\/\/us.v-cdn.net\/6031209\/uploads\/I4UKI5HYCYIO\/formula-png.png","urlSrcSet":{"10":"","300":"","800":"","1200":"","1600":""},"alt":"Formula.PNG"},"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-28T13:34:39+00:00","dateAnswered":"2023-06-28T13:01:09+00:00","acceptedAnswers":[{"commentID":382813,"body":"
The problem is with a misplaced parenthesis. That zero at the end is technically part of the INDEX function, but you want it as part of the MATCH function to denote an exact match.<\/p>
<\/p>
You have:<\/p>
INDEX(.........MATCH(...........), 0)<\/strong><\/p> You want:<\/p> INDEX(.........MATCH(..........., 0))<\/strong><\/p>"}]}},"status":{"statusID":3,"name":"Accepted","state":"closed","recordType":"discussion","recordSubType":"question"},"bookmarked":false,"unread":false,"category":{"categoryID":321,"name":"Smartsheet Basics","url":"https:\/\/community.smartsheet.com\/categories\/smartsheet-basics%2B","allowedDiscussionTypes":[]},"reactions":[{"tagID":3,"urlcode":"Promote","name":"Promote","class":"Positive","hasReacted":false,"reactionValue":5,"count":0},{"tagID":5,"urlcode":"Insightful","name":"Insightful","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":11,"urlcode":"Up","name":"Vote Up","class":"Positive","hasReacted":false,"reactionValue":1,"count":0},{"tagID":13,"urlcode":"Awesome","name":"Awesome","class":"Positive","hasReacted":false,"reactionValue":1,"count":0}],"tags":[]}],"initialPaging":{"nextURL":"https:\/\/community.smartsheet.com\/api\/v2\/discussions?page=2&categoryID=341&includeChildCategories=1&type%5B0%5D=Question&excludeHiddenCategories=1&sort=-hot&limit=3&expand%5B0%5D=all&expand%5B1%5D=-body&expand%5B2%5D=insertUser&expand%5B3%5D=lastUser&status=accepted","prevURL":null,"currentPage":1,"total":5421,"limit":3},"title":"Trending in Using Smartsheet","subtitle":null,"description":null,"noCheckboxes":true,"containerOptions":[],"discussionOptions":[]}">
<\/p>