-
Dashboards - Public Access
I want to be able to share a dashboard company-wide that I have created and make it more than "view only". The dashboard contains 3 forms I want any company user to be able to interact with (without me individually sharing it to each user). How do I accomplish this? Currently, publishing it has only allowed users "view…
-
Integrate with Microsoft Planner
Is there any possibility of Smartsheet integrating with Microsoft Planner? Smartsheet is equipment to manage full portfolio where Microsoft Planner seem to only focus on individual projects. I am a seasoned Project Manager and I need to see all projects at a high level view. Several departments within my organization uses…
-
Multiple users editing a sheet at the same time
I noticed that Smartsheet allows 2 (and maybe more) people to open a sheet in EDIT mode at the same time. It looses the changes made by one of them based on who hits the SAVE button first. Is there is an option which doesn't allow a sheet to be open in EDIT mode if someone else has already opened it in EDIT mode? Thanks.
-
Using MAX Formula- How to formulate it to capture infinite rows
Hey Guys! I have a Smartsheet that is connect to Jira. I have added two columns; Created On (with creation date column) and Last Create Date (date column). I am trying to populate a formula that pulls one text box of when the sheet was last updated. When I attempt to enter =MAX([Created On]2:[Created On]???) it wont work.…
-
Formula Needed for Parent to Inherit Child Value
I don't think this is possible, but I need a formula where a parent row Status value reads "No Active Projects" until it has a child row below it with an "In Progress" status at which point the cell should just be blank. See image below. I use the "No Active Projects" marker to determine whether or not that department…
-
Unique list of values w/ VLOOKUP or INDEX/MATCH not working
I am trying to use the aforementioned functions to crate a list of unique values by referencing a separate sheet. The source sheet contains a column of date values and a column of checkboxes which indicate unique dates. using either functions indicates #NO MATCHES which is incorrect. Please let me know how to make this…
-
API.SmartSheet.Com
I have an application that updates a SmartSheet using the available APIs.. The application uses the C# NuGet packages for Visual Studio (2017) The program has been working flawlessly for over 12months now but as of 1am last night (UK time), I no longer am able to connect getting the very basic error of "There was an issue…
-
OpenSSL.SSL.Error: [('SSL routines', 'ssl3_read_bytes', 'sslv3 alert handshake failure')]
Please advise: Traceback (most recent call last): File "/opt/venv/sheetconnector35/lib/python3.5/site-packages/urllib3/contrib/pyopenssl.py", line 441, in wrap_socket cnx.do_handshake() File "/opt/venv/sheetconnector35/lib/python3.5/site-packages/OpenSSL/SSL.py", line 1716, in do_handshake self._raise_ssl_error(self._ssl,…
-
Make the rich text editor edit report cells on the dashboard
Greetings everyone, I was wondering if using the rich text widget to edit a cell in your report on the dashboard live is possible. The logic behind it is: The rich text editor is linked to the cell from a report and updates data simultaneously. Thus, I wouldn't need to go back and forth to the report and then to the…
-
Is it possible to get a weeks beginning/ending dates from weeknumber?
I have figured out a different set of formulas to get a beginning/ending date for a specific week and month. But have been asked if its possible to use the following: =countif(range, Weeknumber(@cell) = Weeknumber(Today()) to meet a date range criteria (something similar for month). I've tried the following with no…
