-
Contingency duration based on predecessors
I was wondering if it is possible to create a task whose duration is determined by two predecessors, one from backward planning and one from forward constraints. I would like to use this, among others, to show dynamic contingency periods in my project. Let's take the simplest example, a project with the following three…
-
If NOT complete, change end date to TODAY()
Hi I'm trying to automatically increase the finish dates of tasks not completed, that were due for completion before today, to today. Is there any way to do that? Any help would be really useful
-
Highlight Changes with a unique color, shade, or pattern for each user
I would like to submit an enhancement request for the Highlight Changes feature. The tool currently shades cells with a background color if a change has been made in the last seven days. Unfortunately, the same color is used for changes performed by everyone. I'd like to request the ability to customize the background…
-
Form function for SmartSheet
Hi, I have smartsheet to record each building general meeting info, such as building manager, meeting date, building name. In each meeting, we need to prepare meeting supplies (there are around 30 items, such as pen, projector, binder..). I would like to use smartsheet "Form function". Then link is created and I can send…
-
New! Row Edit Multi-Pane View - will this help your SmartSheet efficiency?
Hi, why always separately open the multiple edit dialogue boxes for data linked to a row -when you could have one click optionally open all all simultaneously in a Multi-Pane popup window! - Row Edit, Discussions, Sharing, Attachments, (PLUS even a new feature - part of the multi-pane window showing an email thread linked…
-
formula to distinguish decimal versus percentage (i.e. 1 versus 100%)
I have a report that combines many sheets. Sometimes the values entered as 1 rather than 100% (or .75 rather than 75%). The report is an input into Tempus (Smartsheet partner) and it makes a difference to their application. Is there a way to determine that a value is NOT a percentage? Or require entry of a percentage, or…
-
WOULD LOVE THIS FEATURE
For our use, it would be of great assistance if when you are within a workspace, which is housing, say 50 sheets, you could check all and using the actions button duplicate all sheets. I could then move those sheets to a different folder while keeping the data needed and deleting what isn't. We tried templates but our…
-
Freezing Column Headings for Reports embedded in Sights
Hi there Are there any plans (or was anybody successful) on the topic of freezing column headings in reports. In particular when the report is embedded in a Sight? Thanks for your advice. Regards jan
-
Enhancement request - search visible rows only
Is there a search option that will only return results for visible rows? I'm trying to search for something and I don't want information contained within hidden rows to be returned.
-
Project Management
Hi, we currently have a few web forms, that allow clients to request quotes. These then populate fields on a smartsheet as normal. We have two challenges that I'd like to implement but can't seem to get it right. We would like to give the client more visibility on the status of the opportunities, but for various reasons,…
