Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please
Visit the Current Forums.
Discussion List
Does anyone know what NaN% means?
Hi all, I'm getting NaN% appear on my sheets where that cell is linked to another sheet. The source cell appears OK, and I've tried remaking the link, but no affect. Is this the 2000 links I'm running up against? There are a lot on my sheet.... Regards - Roland
IF formula
May I please ask assistance to help generate the following IF formula. Depending on what number value is in column 1, I want the column 2 to it to return a certain value. If in column 1 the value is >980 then return the value in Column 2 to "Excellent" If in column 1 the value is >950 but less than 980 then return the…
Symbols not appearing in reports
When generating a report, my status symbols are displaying as text not as a symbol but are a symbol in my project plan. This has only recently occured.
resource-based Notifications per line item
Hi community I recently created a sheet which employees in our company can complete through a webform. I was wondering if it is possible to send a notification to one of our team members in case a certain field is chosen (dependency driven notifications). For example, if a record is added by an employee and one of the…
Widgets do not make it into reports
I am pulling a report on a project that has a progress widget. It is a status bar. When i pull the report i get he list below. Why is that? I am assuming this is a bug? In fact, now that i think of it. I think the widgets used to be there but now they are gone after the update. Three Quarter Three Quarter Empty Half Three…
URL to attachments
Is there a way to create a URL from a smartsheet attachment?
How to use indet and outdent in spreed sheet \ googal sheet.
How to use indet and outdent function in googal sheet \ spreed sheet.
Export from Tableau into SmartSheet
Hi all, I am aware of an ODBC connection that allows us to display SmartSheet data in Tableau dashboards. Is anyone aware of a way to export data from Tableau automatically into SmartSheet? (i.e. - the reverse flow of information to the existing SmartSheet-Tableau interface). Perhaps someone else in GE has developed…
Discussions - Allow html and embedded images
I would like to see if under the discusisons section of an entry if the discussions can be updated to allow html graphics. There are times when we have to copy/paste into the discussions field and we are copying from an outlook html email. Many times users will embed images into the email and/or their signature or other…
Checkbox % formula
I have a checkbox column, no children, and I want to calculate what percentage of the checkboxes are checked for a specific range. Is there a formula that could do that? Thank you!
