-
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…
-
Counting Check boxes when Checked
Hello, I would like to find a way for a way to count the check boxes when they are checked. Ideally, I would like formula that allows me to know what date it was checked. I'm not sure if the modified data column can do this because I do not have sufficient data at the moment. Another solution I'm thinking is possible is if…
-
Submitted Web Form - User Information
We are creating a web form to track business development possibilities. Other than adding a "Your Name" field to our web form, is there a way to see who submitted the form? On a current smartsheet where we are using a web form, I can right-click to view history, but it shows only "web form user". What we would like to see…
-
Date miss matching
Hi all, Ok so I reside and work for a company based in Bangladesh and we use this format for date ( Date / Month / Year ) so today will be 30/3/2019 I have two base sheet that feeds directly to a master sheet via direct cell linking which is used by the management to keep track of the latest updated. Now the base sheet the…