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. Archived 2016 Posts
Archives for May 2016
Discussion List
what is the best way to get rid of #DIVIDE BY ZERO ?
what is the best way to get rid of the results of #DIVIDE BY ZERO. I have tried conditional formating, but that doesnt work. I am not having any insight with the if formulas. Thank you, Jef
Formulas
What is the formula to add 90 days to a range of dates that yields MM/DD/YY as the result in corresponding cells?
Office365 integration also available for Google / Box?
Found this interesting video: https://www.youtube.com/watch?v=81yUUo9ejCs Anyway this will also become available for Google / Box?
address formula
What would be the formula to separate the address into plus for separation. I have tried a few different ways and haven't had sucsess.
Using smartsheet for grant writing
I am a grant writer at a nonprofit and my development team uses smartsheet. I am at the beginning stages of using smartsheet and want to use it for EVERYTHING related to my grant writing (calendar, deadline tracker/notifier, links to emails, links to webpages, task list, grant applications, anything else you can think…
What is wrong with this formula in totaling in parent row?
I have a parent row I just can not get to toal the "Win Ratio" (it is a percent) if there is a ZERO in one of the child rows! It is driving me crazy! The colums are: Phone Calls | Accts Created | Win Ratio The Daily formula works even when there is a ZERO in it... I am using this: =IF(AND(ISNUMBER([Phone Calls]18),…
Smartsheet patch updates?
For at least the second time recently (since the May 7th update), I have been requested to refresh Smartsheet because of updates. The timing strikes me as odd to (3pm on the West Coast). Is Smartsheet pushing patches without updating the release notes? Thanks. Craig
Enhancement Request: Show indent levels of project tasks in reports
I would really love to see the indent levels of tasks in report based on a project plan. Today all tasks are shown left-aligned. With a rising count of tasks, subtasks and subtasks of a subtasks (and so on) it becomes confusing and unreadable. People not as deep into the plan as the project manager get totally lost very…
Multiple section in a dropdown list?
Hi, Is there a way to select multiple items in a dropdown list? Here is the scenario i am trying to solve for. A product roadmap project may can be related to multiple products. I currently have a dropdown list column for products and each row is project. Currently i can only select one product per project. ideally i would…
Report by User logged in?
Is there a way to create a report that filters the underlying sheet by the user running it? For example in SharePoint, you can create a view, so that whomever is viewing it will see just their records according to a column by entering a filter in the view setting the column to equal [Me]. Is there something similar in…
