-
Predecessor Content Change in Report?
Recently I have noticed that what is displayed in the predecessor column when running a report has changed from showing the specific line dependencies to now just showing the number of predecessors ( i.e., 1 Predecessor, or 2 Predecessors). This isn't really of value when looking at a report. Is there a way to show the…
-
Smartsheet and HIPAA
Hi Community ... Sharing a bit about HIPAA from the team who helped implement Smartsheet's HIPAA guidelines. Here's the very short synopsis: Smartsheet does not collect or store PHI as part of normal business operations; however, any HIPAA-subject organization with an Enterprise plan that works with PHI can enter into a…
-
How often does a report update?
We are using a Smartsheet Report to upload data into a third party system. We are curious as to how often the Report will update. Example: If we open one of the Smartsheets that feed the Report and make a change and we do not open the Report, then when the third party system pulls data from that Report, will it have the…
-
RYGB Balls
I created a nested function to color designate the status of my projects tasks: =IF(Status="Not Started","Red", =IF(Status="In Progress","Yellow",=IF(Status="Complete", "Green",=IF(Status="N/A","Blue)))) The Red, Yellow, and Green balls work perfectly, however, when I select N/A from the drop down in the cell I get…
-
Text under "Comments" Column is in a strange position. How can I fix it? Thanks
Hi, the text should be under "Comments," not over it too (see highlighted text). How can I fix it? Thanks
-
Change Column Name in Multiple Sheets
Is there a method to change column names in multiple sheets? (I'm aware of the impact on reports that include those sheets.) It is very labor-intensive to change the column names in multiple sheets, but that is how we work in the real world. Change, change, change. I've already updated the template, but wow what a pain to…
-
maximum rows on a report
What's the max rows anybody has pulled into a report? Checking with Support, but curious in regards to functionality. The report will contain 65 columns. I've pulled over 5000, but I could have more for a new project we've rolled out. thanks, Tim
-
Duration Column Doesn't SUM up Correctly
Hello, I am using smartsheet for my master project plan and I repeatedly run into one issue, my project Duration count roll up is inaccurate. I have attached a screenshot to provide a better understanding of the issue.
-
Comparing Actual Duration to a Projected Duration with a +/- days
Three columns used are Duration(dependent), Projected Duration(I initially copy all of the durations over when setting the project) and +/- days(calculates the difference between Duration and Projected Duration) The trick here is you need to strip the "d" from the value to allow computations. =(VALUE(LEFT([Projected…
-
Hide or reveal a web form question based on answer from previous field
Is there a way to hide or reveal a question/text input field in a web form based on the answer from the previous question? For example, I am creating daily truck check forms for our paramedics and one question is "how many back rafts are there?". The dropdown list choices for them are "3", "Restocked", "Ordered" and…
