-
Printing Dashboards with Dividers
I don't think this was resolved in the new version of dashboards but thought I would check. I have dashboards that have colored dividers between the sections (screen shot would not appear so it's in the attached). When I print to PDF, they disappear. I really like the look with the dividers and have not come up with a way…
-
Format cells in sheets and reports that have an update request
Has anybody found a way to highlight (change cell color or format) a cell or row in a sheet, once an update request has been manually requested by a user? Additionally how can the same highlight be extended to reports built off of that sheet? We have users manually requesting updates to a single column in a report, but as…
-
Update Request does not allow editing field
I have a workflow that sends an update request to each resource assigned. I'm trying to get them to update "% Complete", but it's showing as uneditable. The user is an Editor, and it does allow them to edit other fields, such as Task Name and Resource Name. The % Complete is not a locked column, and the row(s) are also not…
-
Search for a comment by a specific person
OK, haven't used the platform for a while, but can't figure this one out. I want to search for a comment by a specific person. I need to find all comments made by that person on my active sheet. I'm talking about the little comment/conversation bubble on the left side of the sheet. I can export the sheet to Excel, and then…
-
help with a formula question
Hi, I'm trying to use this formula to evaluate whether a value should appear Red, Green or Yellow by multiplying to other values in the sheet, but I keep getting an #unparsable error. =IF(sum([Severity]1*[Probability]1) >"1.0", "Red", IF(AND(sum[Severity]1*[Probability]1) >".50", (sum[Severity]1*[Probability]1) <".75"),…
-
Specific formatting within pivot report?
Hi there, I have a pivot report that lists staff resources and the count of projects each person has per month. Is there a way to have some sort of visual formatting added to alert the viewer when a person has more than a given number of items per month? Right now, I can apply conditional formatting to entire columns or…
-
Smartsheet Report builder not printing exactly the same view in the Report
Hi, Anyone had tried to print the Report with Summaries, filter and group "ON" and did not print the way it should be? Everytime, I export it in pdf file or print it, it is not showing how it was summarize and group like in the Report view itself. Anyone know how to print it correctly?
-
How do I stop Smartsheet from auto-filling dates?
I have a Smartsheet where there is a Date Received column and a Due Date column. Neither one of these columns contains a formula. When I enter a new row, as soon as I enter the Date Received, Smartsheet is auto-filling the Due Date column to match the Date Received. 99% of the time this is incorrect. The intention is that…
-
Creating a Time sheet form which shows existing projects as drop down
I am evaluating Smartsheet and one of my use cases is for my team to be able to enter time spent against projects which have been approved. I am trying to find a way of being able to include in the form a reference to my project master sheet but can't seem to find a way to achieve this. Has anyone been able to solve this…
-
Automation - Alert When a Certain Number of Rows have been Added
We're using a form/sheet to collect registrations. Is there any way to set up an alert when a certain number of registrations (rows) have been submitted?
