-
=COUNTIFS Specific Dates
I am trying to count the number of times a specific schedule date is listed in a column for a sheet, not able to narrow down the formula exactly
-
dropdown list
I have a first sheet name 'customer contact' On other sheet name 'report' where I use the customer contact list to make a dropdown list. My question : It is possible to refresh automatically the drowpdown list when I add a new contact in the sheet customer contact? Thanks per advance for your time and support. Best regards.
-
Retaining Email Messages as comments
Is there a way to retain email messages as comments, when they are sent directly from a row in Smartsheet? If not, this would be a great addition.
-
Percentage complete of blank/not blank dates in a column
I am looking for a formula that can show me a percentage of blank cells/non blank cells in a column. Ex: My Column is titled: CPD Complete Date. There are 10 cells in the column Only 5 of the cells have dates I would like a formula that can show this is column is 50% completed based on how many blank cells there are to how…
-
Countifs with multiple criteria
Hello, I am trying to figure out a formula to capture a specific person and how many opened or closed cases they have. My fields are Analyst and Date Closed So for the analyst, let's say i am trying to find out how many cases Leslie King still has open, that would be annotated with the date closed field being blank, and…
-
Need data to appear in two sheets, reflect one sheet
Greetings Folks, is there a formula that will allow me to reflect the data in one cell from a different sheet into another sheet? Basically, there is a team that uses smartsheet and they have sheets all over the place. I need one sheet with specific data in it and want to just pull the data out of their sheets into this…
-
Send Update Request Grayed Out
Hello! When I right click on a row, the "Send Update Request" is grayed out and I am not able to click it. How do I fix this?
-
Automate approval by row
I have a sheet which requires updates and approvals by multiple individuals. I want to create an Automated Workflow that assigns approval by row, whenever there is any change to that row. All rows, obviously, have the same columns. In other words, I want to create an approval workflow for each row so that the person who…
-
Trouble installing python API
Hello, I am having problems installing the python API. I receive the following error message when I run: %> pip install smartsheet-python-sdk --upgrade Here is the output I see: Collecting smartsheet-python-sdk Retrying (Retry(total=4, connect=None, read=None, redirect=None, status=None)) after connection broken by…
-
Update on Time Options?
Hi - I have been searching through old posts and I see many mentions of a new feature that's hopefully coming soon to be able to track time in a column (24 hour format would be great). Any update as to when this may be available? Thank you!
