-
Release 2016-08-06 INDEX function?
When was the INDEX function released? Was it this one? I can find no reference to it in the release notes (searching the whole page), the last version of the Formula Examples does not mention it nor does the blog entry for this release. It is mentioned here: http://help.smartsheet.com/articles/775363-using-formulas but…
-
When I save or refresh, I lose all my hidden columns and Filters.....WHY!!?!?
Please guys, before you add new functionality please make the existing framework stronger. NOT being able to sort while filters are on is not only extremly annoying and fustrating (I spend almost halfy my time unfiltering to sort cloumns to get the information I need), but should be an easy fix for development! When…
-
Misc feature requests
The following features/enhancements would be useful: * -Card view also for reports * - Conditional formatting applied in reports * - BOX task integration (tasks assigned in BOX could be displayed as a separate report) * - Reports from reports, not only from sheets. This would enable more advanced filtering * - A report…
-
#invalid operation (new w/update)
In addition to the new features of Smartsheet brought about with the latest update, I'm also now getting #invalid operation error with this formula: =IF(AND([Start Date]285 - TODAY() = 0, [End Date]285 - TODAY() = 0), "Gray", IF(AND([Start Date]285 - TODAY() <= 45, [Start Date]285 - TODAY() <> 0), "Yellow", IF(AND([Start…
-
#INVALID OPERATION
Guys, Something went wrong with the latest upgrade, I have too many spreadsheets to fix, this formula now give a #INVALID OPERATION error, this is one of my formulas: =IF(ISBLANK([Paid Date]5), [Due Date]5 - TODAY(), [Due Date]5 - [Paid Date]5) Please can this be resolved.
-
=COUNTIF above a row
Hello, I'm wondering if there is a way to set the range in a =COUNTIF function to only count above a specified row. We currently use a form to generate actionable rows the the top of the smartsheet. As items are completed we move the actionable row to a collapsable archive parent row. I want to set up a function to…
-
Moving an attachment from sheet to sheet?
Hello everyone, Via a webform upload, an attachment currently comes into a main sheet. I'd like to be able to send that attachment to another sheet on row of my choosing. I do not want to "copy row" or "move to another sheet" as the fields are not all the same Is this possible?
-
Low Priority Feature Request - Split Screen View of two different sheets
Its a nice to have feature, not as important as the other stuff I mentioned.
-
Resource management and parent/child hierarchy
Hello I've created a sheet with a list of projects (the name is the parent). The child rows contain the team members name (assigned to column), allocation %, role, etc. I've got the sheet working to where the red man shows on the rows where there is a resource issue. Unfortunately that only seems to apply to the child…
-
How can i see who has changed which portion of the sheet?
Hi, I am having a situation wherein we are 2 Admins sharing the same Project sheet. I know that this is not the best way of handling the project/sheet. I would like to know, how do i see which portions of the plan is updated by my counterpart? I see a message that some changes are done and i need to refresh the sheet. I…
