-
(2) Reports in a Dashboard Showing the same answer?
I have 2 reports sitting next to each other in a dashboard. One shows a summary of what was due yesterday. One shows a summary of what is due in the next 5 days. "Due Yesterday" report is set to show anything with an End Date in the last 1 day(s) "Due in the next 5 days" report is set to show anything with an End Date in…
-
Designating who gets a back up email
Is there a way to change who gets notified of a recurring back up? Right now it states the workspace owner will get notified. Is there a way to designate who gets the email other than the workspace owner? Thanks, Paul.
-
"Recently Opened" Navigation bar Question
Hello All, I have been a huge fan of the "recently opened" Navigation tab and have about 30 sheets pinned. I do use various sheets at various times, however, and would like to rearrange the order of these sheets as well as be able to bucket them. I understand that this wasn't quite the point and workspaces/sheets were made…
-
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.
