IT & Operations
Discussion List
- need a function in smartsheet to set permission to one cell,or one column, it means, the viewers can view most of the datas in the sheet,but one or two cells,one or two columns,take the classified col…
- Hello, I have been creating metrics on my data in smartsheet using the different formulas. I have figured many out (with a lot of head banging and sleepless nights), but cannot figure out how to use t…
- Hoping I've not missed something obvious, but is it possible to use "Current User" in a formula? I would like a cell within a task list to count all tasks assigned to the current user with either of 2…
- Hello! I'm looking to utilize a Dashboard or Report and can't, for the life of me, figure out the best way to do this. I need to give a summary of units sold to a customer, per product type, per year.…
- Hello, I am creating dashboards using metrics and am trying to figure out a way to only show the top 15 of specific data. Sheet details: I have one column that contains 298 different locations and the…
- The possibility of being able to clone rules across sheets has been mentioned before in a couple of posts, but I want to raise the issue again because of an incident that occurred last Friday. A key S…
- Hi All - I am uploading a .csv file into a Smartsheet sheet. One of the columns within the .csv file is formatted to contain '$ prior to the numbers within the cell (so when opening in Excel, it will …
- I have one column that shows what a risk is ranked as (a score from 1 to 49 with 49 being the most risky). I am trying to put in another column that lets a ranking for the effectiveness of the mitigat…
- I have a sheet where I am using a Webform to gather data. Issue is the Sumif formula I have at the top of my sheet will not include the added line entries of the webform entries. =SUMIF(Task2:Task4, T…
- I am trying to have less restrictive settings to send updates to people who aren't shared to my sheet. The help section suggests that: * Open the sheet and click Alerts & Actions > Manage Alerts & Act…
