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 2017 Posts
Archives for November 2017
Discussion List
Archive Comments?
Is it possible to archive comments on a specific row without deleting them all together? I'd love to be able to archive them to be able to read at a later date, but want to just see new / unread comments on each row that we need to take action on.
Report not following set up description
I have built a report that is suppose to show those tasks that are not completed by the due date. I've set it up to look for "today" or "in the past" when "the status ball is not green". On a few of the tasks it still lists the task in my report even though the status ball is green. Any ideas on how to fix that?
Formula needed
I am trying to set up a formula that will subtract from a given value, each time that item is found. I have a form that my team will be using to enter data (item) and how much they found (subtract from value). In turn, I need to have a running total of what is still not reported for each item.
Default form date to Today + constant
I am creating a form that un licensed users will use to submit requests. I want the default for the form to be Today + 4 business days. Is this possible? It looks like the default date can either be hard coded to a specific date, or set to Today. Any help would be appreciated!
Zooming on Chart
Hi there, I am trying to zoom into the chart basically from the beginning of November 2017, til the end of February 2018... However it either zooms in WAY to far or not enough, so when i print it, it either prints 6 pages or just 1 but it is hard to read. Is there a way around this? Like maybe a scroll in to zoom? Thanks.
Default Parent via Form?
Is there a way in a form to choose a default Parent (Feature) and Grandparent (Epic) to help facilitate initial viewing in card view? Creating the story one at a time under the feature is a nice quick dirty way to create a placeholder story, but if you want to use a form to enter lots of information about the story it…
Weeks Out Calculation based on Nested IF Statement
I'm having trouble having my weeks out calculation work based on the results of a Nested IF Statement. The If Statement works if I use quotation marks around the results which need to display a date. The problem is that putting the quotes around the results converts the number (in my case a date) into text and no longer…
#INVALID DATA TYPE formula Return
The first formula below is returning a #INVALID DATA TYPE when I enter it. But in the second formula the equation works and I am not sure why the first one is not. What am I doing wrong with the Fiscal year part? does not work: =SUMIFS([Total With Service Charge (18%) if Applicable]:[Total With Service Charge (18%) if…
Notifications
Hi Guys, Im trying to set auto Notfication I have a Project sheet with Date type of coulmn called "Last Updated" I have another text Column Called balance Due I want to Create a notification if Balance due is higher then 0.00 Send Reminder 2 days after the date in the last updated Column and if not do able with smartsheets…
Reports - Hide the original sheets
We have master sheets that contain information on all products across 6 factories. We want to create a report for each factory that they then update relevant information for their products. This then allows all data to be viewed in the master sheet. The problem is that the report will show only the products that they have…