-
Enhancement Request: Allow Filter of Attachment Summary window
It would be useful to allow even limited filtering of the Attachment Summary windows (Workspace, Sheet, Row). For many attachments, it is likely that none of the sort options will 'consolidate' the attachment list into a easily usable list. I can, of course, select multiple attachments and download them to my computer.…
-
Enhancement Request: Allow Sort of Attachments default to be saved
In the Attachment Summary dialog windows (Sheet, Workspace, and Row), allow user to select default sort option. Currently, Sorted by Date is ALWAYS the default and when returning repeatedly to the same summary to retrieve multiple attachments over the course of a workday, the date is not the easiest / quickest way to…
-
Past Due Formula Help!!! - IF / AND
I cant seem to get the formula correct for this scenario: If "End Date" is Past Due AND "% Complete" is NOT 100% = "Complete" to turn flag red in "At Risk" column Am I correct that the formula would go in the "At Risk" column?
-
Count Blank Cells
Hi I am using Smartsheet for invoice approvals and would like to summarise how many documents are still awaiting approval. I have tried using a countif formula to count all cells that are blank in a certain column, however I get results that include lines are not used, e.g. there are 10 documents entered on separate lines…
-
Project Presentation
I have a project presentation that will include booth visual and date, does anyone have a template i can use?
-
WEB FORM AND CELL LINKING
Is it possible to link cells from a Smartsheet that is filled with a Web form, adding automatic linking to the new Smartsheet? I have a Purchase Requisition that is filled with a web form but I want to link every purchase that is entered with my Finance sheet. Everytime a new PR is entered, the row is added on top and the…
-
Tracking equipment assignment schedules
Another dept is looking at specialized software to track Evaluation units we have in the field. Then someone said "maybe SmartSheet can do that". Here's the picture: 1. We have equipment, identified by SKU and serial number. 2. We have organizations using this equipment. 3. We want to track where a piece of equipment is at…
-
Display predecessor task NAME
We would like to write logic to display all predecessor task NAMES in a new column. So we want the predecessor task ID to be in its usual column, and we want a NEW column that shows the NAMES of the predecessor tasks. Anyone done anything like that? Thanks Robin
-
Sum a range based on the status of a check box
HI, I am in desperate need of formula help. Nothing I try seems to work without getting #UNPARSEABLE I require a formula to calculate the total of costs based on if another colum is checked. Prices quotes colum against approved checked colum.
-
Hide formula error message
Hi, I have set a formula up to add 7 working days to a date: The date is added once an action is completed. =WORKDAY([Date]1, +(7)) If the source cell is empty I get the error message #INVALID DATE TYPE Is there any way to hide or remove the error message. Thanks Hugh
