-
Sheet Summary Report - Want to edit fields within report
I created a Sheet Summary Report, and have found that the fields within the report are not editable, unlike a Row Report. In a Row Report, I can click into the cell directly within the report and update it. On my Sheet Summary Report, the cells in report are locked down and uneditable. Am I missing something in order to be…
-
Formula Help - Countif in Multi-select column
Hello - Two formula questions: 1. I am trying to input a countif formula into a Summary field that will count how many times the name of a specific team appears in a column that uses a multi-select dropdown. This column also has some fields that are blank. Below is what I have tried and am receiving an 'Unparseable' error.…
-
Random highlights appear
We have noticed over the last 6 months or so, that there is a persistant bug when using the "highlight changes" feature. The smartsheet will highlight changes within the given date range. However, it will also highlight other random cells. The highlight will also disappear if you move the cursor over it, but will reappear…
-
Need to calculate an Expiration date
I have a sheet that I have included the current inspection date. I need to calculate two expiration dates. One column @ 90 days post the inspection date and one column @ 365 days post the inspection date. Any help would be greatly appreciated. Thank you, Nicole
-
Biotech or Pharma companies
are there any Biotech or Pharma companies using Smartsheet that I can speak with regarding setting system up. Our finance group set the system up to track POs & Invoices, however Clinical needs the system to incorporate timelines and milestones.
-
Copy a set of sheet that have links
I have created a set of sheets that I will use to managed various parts of a Project. Between the sheets, I've linked a number of cells, pulling data from one sheet to another. As I'm going to run this type of project many times, I need to copy this set and reuse them for another project. I can copy the sheets, but the…
-
Using symbols in cells and then averaging those cells
I have a portfolio level DB and am using health field symbols. I want those health field symbols to equal 1, 2, 3 and then take the average to provide a program level health. I have tried this IF([Cell] = "Green", 3, IF([Cell] = "Yellow"), 2, IF([Cell] = "Red"), 1, ""))) But am getting unparseable error.
-
Sharing Report to non-licensed users
HI, I am trying to share a report to users (not licensed) but can only get them to see the sheets in the report if I give them a license. I have shared the relevant sheets with the users. Before we signed up to the paid account this was an option. Thanks, David
-
Prevent Formula Overriding
Hi there! I have a column set up to indicate Task Progress (can choose from dropdown: Not Yet Started, In Progress, Nearing Completion, etc.) but also would like it to automatically mark "Complete" if another column (checkbox formatting) has a marked checkbox. The issue I'm having is that the formula erases if someone…
-
Limiting Auto Number to Specific Range
Hi, I'd like to add an auto number column, but I would like to set the specific range in numbers. For example, I need the auto numbers to be between 0 and 250 without duplicating. Is there a way to set those limits? Thanks. Jay Duque