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, pleaseVisit the Current Forums.
Thanks Brett. I am not sure there is anything like free account. To test this, I sent an invite to my seconday email address and I got the message it is a trial account. I have only 29 days left to upgrade from this new account.
Peter, the HTML publish does not have the security control other publish options allow as it is a lightweight view. If you are looking for a similar view try a publish sheet with viewership restricted to the org only. To do this, you must be on a Team/Trial or paid Team account. You can enable this by following these steps:
If you are not on a Team/Trial you can switch your individual trial to a team trial through a variety of ways. An easy way is to start the flow of adding another user to your account. To do this navigate through
Account (top left gear) > User Management > Add User. When prompted to add an account name enter one. You are now on a team trial.
Now that you are on a team trial, you will be able to see these options on Publish - Read Only and Publish - Edit. If you keep the left toolbar hidden and add a custom logo/color scheme you will have a personalized view of the sheet to safely share within your org. When accessing the publish link, users will be prompted to login if they are not already. If they are not in your account they will not be able to view the published sheet.
Here are the options:
Org administrators are also able to restrict sheet publish account-wide in Account Settings.
I do have Team account. I was playing with this feature you mentioned yesterday and found that this works for what I am looking for. We have lot of users who are read only and the HTML is easy way to share the info. So the issue I have is that we will end up paying for all such users who are just consumers of the report.
Do you guys have a special rate for such kind of users?
How about using the embed code to put the published sheet on a company intranet page? Then you could control access with a company log-in and not pay for all the extra Smartsheet licenses.
\"//m.santa-greenland.com/community/discussion/comment/\", [Project Lead]:[Project…","snippet":"This formula is currently working, and it is returning how many items are reviewed for each \"Project Lead\". The first part of the formula is basically saying that we would count…","categoryID":322,"dateInserted":"2023-06-29T22:39:31+00:00","dateUpdated":null,"dateLastComment":"2023-06-30T02:51:05+00:00","insertUserID":157974,"insertUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"updateUserID":null,"lastUserID":157974,"lastUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"pinned":false,"pinLocation":null,"closed":false,"sink":false,"countComments":2,"countViews":19,"score":null,"hot":3376173036,"url":"https:\/\/community.smartsheet.com\/discussion\/107113\/how-to-return-a-blank-if-we-have-a-blank-cell-using-a-countifs-formula","canonicalUrl":"https:\/\/community.smartsheet.com\/discussion\/107113\/how-to-return-a-blank-if-we-have-a-blank-cell-using-a-countifs-formula","format":"Rich","lastPost":{"discussionID":107113,"commentID":383252,"name":"Re: How to return a BLANK if we have a BLANK cell using a COUNTIFS formula","url":"https:\/\/community.smartsheet.com\/discussion\/comment\/383252#Comment_383252","dateInserted":"2023-06-30T02:51:05+00:00","insertUserID":157974,"insertUser":{"userID":157974,"name":"Filippo","url":"https:\/\/community.smartsheet.com\/profile\/Filippo","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/defaultavatar\/nWRMFRX6I99I6.jpg","dateLastActive":"2023-06-30T03:08:32+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"}},"breadcrumbs":[{"name":"Home","url":"https:\/\/community.smartsheet.com\/"},{"name":"Formulas and Functions","url":"https:\/\/community.smartsheet.com\/categories\/formulas-and-functions"}],"groupID":null,"statusID":3,"attributes":{"question":{"status":"accepted","dateAccepted":"2023-06-30T02:51:53+00:00","dateAnswered":"2023-06-29T22:55:01+00:00","acceptedAnswers":[{"commentID":383233,"body":"