-
Persistent formula cells
MS Project has a lot of built in features that SmartSheet just doesn't have. Such as calculating if something is late, setting a deadline that flags if the date moves, calculating AWC and SWC, etc. To that end I have created a bunch of hidden cells that do all the needed functions and checks, and then built the…
-
Tablet Web Forms (How to?)
I have an Android Tablet (don't judge me). There is a section for Web Forms. How do I add a Web Form to the list? I searched the Help Center without finding an answer. Craig
-
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…
-
Sheets populated by Web Forms
I have a sheet that is populated by a web form. * The production floor inputs data into the web form. * The quality lab is "View Only" on the sheet. (on a display screen) Is it possible for the sheet to auto-refresh when new web form results have been added? The goal is - as soon as new info is added from the production…
-
IF(OR Formula Help
What am I doing wrong? If Required Column, Rows 23-34 are "Yes" OR "No" THEN show "Yes" symbol, if NOT show "On Hold" This is the formula I'm using: =IF(OR(Required23 = "Yes", Required23 = “No", Required24 = "Yes", Required24 = "No", Required25 = "Yes", Required25 = "No", Required26 = "Yes", Required26 = "No", Required27 =…
-
Project Presentation
I have a project presentation that will include booth visual and date, does anyone have a template i can use?
-
deleted columns continue repropagating
There are a couple of columns that continue propagating even though they have been deleted. They are actually redundant columns already present on the sheets. Each day, I must delete them from every sheet. I have looked at sheet settings and to my ability, have found no answer.
-
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…
-
Bucket sections according to status
I have a task list for setting up a vendor. Several teams will update the sheet when they have completed a step in our process. We want to make this as easy and simple as possible but what I would like is to put the Vendor Names sorted by Status and group them that way. And when their status changes they move to the next…
