-
Report ignoring "is blank" parameter
Hi all, We have a report that is suddenly not functioning properly. The report pulls all projects that do not have a Start date and has been functioning without issue until this week. Two of the newest projects given dates are still showing up in the report after deleting and re-entering, refreshing the report, rebuilding…
-
Freezing Column Headings for Reports embedded in Sights
Hi there Are there any plans (or was anybody successful) on the topic of freezing column headings in reports. In particular when the report is embedded in a Sight? Thanks for your advice. Regards jan
-
Can I remove the 'login' link when sending a row by email
We are using a smartsheet to create and sending accommodation quotations. If I send a row of data by email, the recipient gets a nice view of the data in a vertical format, but sees a 'login' link at the top of the email. This is confusing for the recipient as they cannot login to the smartsheet account - we do not want to…
-
Attempting to use SumIfs where 1 column could have multiple different values.
Hello! I have tried to find the answer by browsing through questions already submitted about sumifs but I can't seem to find a question that addresses my issue. Apologies if this has been asked and answered. I'm attempting to sum a column based on the values in 2 other columns. my column headers are: Sprint, Task Hours,…
-
Financial Year - Weeks view in Gantt chart
Hi I am wanting to display the FY weeks in Gantt view, not Fiscal year. Is there a way of doing this?
-
foreign language support
Does anyone know if it is possible to change the language in the date column of gantt sheets? Elsewhere I seem to be able to name columns etc in any language I want, but the months and days seem to be fixed. Many of my workers in China cannot read roman letters at all, let alone understand words, so it is an issue for us.
-
DataMesh User Guide / Training
Hi, Are there any user guides or training videos on how to use Smartsheet DataMesh? Thanks
-
Forms in a Template
I have been successfully using a template to create project plans with a form. I've created dozens of sheets from the template with no problem having the form transfer from the template to the new sheet. This morning that stopped working, so when I create a new sheet from that same template the form no longer carries over…
-
Formula for a new Sight
I want to find out the min, max and avg days taken to complete a project. We have around 68 management systems. So, how can I put a condition for say ABC system was used in 6 projects (from its column) and find out the min, max and avg of the days taken to complete it. In simple words, I have two columns 1. Management…
-
How to clear the clipboard?
Hi there, I am having difficulties with copy & pasting from one sheet to another, i.e. when I copy some new cells it still pastes the previous cells that I pasted. Does anyone know how to overcome this / clear the clipboard? Thanks, Paul