-
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!
-
Update triggered by day of month, repeat daily until complete
Sending a single update request does not always generate a response because many people are not good about answering all their emails, and then it gets lost in old email. I'd like to generate a daily update request that begins on a set day each month (like the 14th) and repeats daily until the person completes the update…
-
Any workaround if database exceeds 5000 rows and need vlookup function from other sheets
If I need a database page where other sheets can pull information from it, to standardise data input, but having the following criteria/situation: 1) database page will keep information for 1 year (database = employee data) 2) will exceeds 5000 rows / 25,000 cells within the 1 year duration 3) cannot move row away as other…
-
clone filters from one sheet to another
Hi, I set up 5 filters in one sheet. I have 20 more sheets with the same columnar structure. I want to "clone" the 5 filters into all the 20 sheets. I don't want to do it manually. I don't want to do the "Save As New" because the 20 sheets have been established already. How can I do it? Thanks, Shinya