-
How do I change a user's login name
What is the correct process for changing a user's login name after they have a name change (marriage, incorrect spelling when created, etc) I see I can change the first name / last name, but I'm not able to find out how to change the login / email address.
-
Search for specific user
As the owner of multiple sheets, reports, sights, etc., is there a way to search all of these where a specific person has been given permissions? Simply put, we have a team member leaving the company and I need to remove this person from any all sheets, reports, sights, etc. and I am hoping not to have to open each item to…
-
Client Invoicing
Hi, I just signed up to the trial of Smartsheet today, so I'm very new to all of this. I'm wondering if we can use this for client invoicing. As a start, I have set up a sheet that lists employees, which includes a "Client" column to whom their time should be billed. For each employee, I have set up a separate time sheet…
-
Exporting History Data
I would like to export history data from an existing project, and tabulate the history data in excel. For example, I would like to see how finish dates have changed over time, for hundreds of rows, over the course of a project that has already finished. Is there a functionality to export a cell's (or selection of cells, or…
-
RYG symbols and nest IF's
I'm new to the community and frankly new to Smartsheets... I'm building some RYG indictors to give a quick visual indicator when a task is at "risk".. my nest IF statement is set to track a task against TODAY() - Finish... ie the closer the Finish date comes to Today's date, the higher the risk. My challenge is the Green…
-
Programatically select a subset of a column
I want to be able to average, or other function, over a subset of the cells in a row. The number of cells I want to include is specifiied in a separate cell. In Excel, I accomplished this with OFFSET. I read another article here noting that smartsheet doesn't have OFFSET, but that MATCH and INDEX might be able to be used…
-
Notification within smartsheet is not working
Hello, I don't receive any notification when other users made a changes! any ideas?
-
Index and Match - Referencing a different sheet
Is it possible to do an Index and Match referencing another sheet? My formula works when I am using data on the same sheet but when I try to reference a different sheet it does not work.
-
Cell Linking/Formulas in Reports
Has anyone worked on implementing cell linking from reports to worksheets and customizing reports? I dont see much in having reports if you cannot customize certain things after running, such as: formulas for totals in reports, conditional highlighting in reports, adding custom columns in reports. Also, without a cell…
-
COUNTIFS criteria is CELL+anything
Hi, I've created a rather complicated cross-sheet formula that counts cells from a different sheet using 3 criterias. One is the description that starts with a text mentioned in a cell above. I've tried to enter the search criteria into the formula like this =COUNTIFS({Other sheet Range 1},$Column$14 & * , ...)…
