-
How do I get a column that shows the automated % complete for each activity?
I am struggling to get any formulas to work, I need a column that shows the percentage complete from the start date to the finish date - shouldn't be that hard but this is causing me so much grief. Every formula I find doesn't seem to work and I am not savvy enough to know how to update the formula so that it can work.…
-
Planned vs actual progress (Summary level)
Hi everyone, I am trying to calculate the % Planed based on the start and finished dates but when I try to set the Complete (actual) progress just to verify that all of my plan y on date, I see that the summary tasks are not calculated correctly. I am using the following formula =ROUND(IF(TODAY() < [Baseline Start]@row ,…
-
AppSheet - Image upload to cells crashed
Hi All, We have AppSheet integrated with Smartsheet as our User Interface in the field for use in inspections. We like AppSheet as it displays and presents data better, and uses Smartsheet's sheet as source. However, as of around Monday 1/September, we noticed that we no longer can "upload" images using AppSheet and save…
-
using intake form, data populates and emails me but no project is created
Title is kind of the question — why wouldn't the emailed content, a copy of data I entered to the Intake form, also create a new project on the project sheet? Thank you.
-
Export Timeline view?
Hello! I am looking to use the Timeline view as a visual for presentations and wondering how I can export it into a pdf? If this is not possible, then also wondering what other solutions from Smartsheet would provide a similar visual for program management needs? Thank you!!
-
Looking for assistance with a formula
Hi all, I am new to formulas and functions in Smartsheet and have a large sheet that I would like to summarize using an "average" formula/function. I need to include at least 2 separate criteria to filter correctly and I am having trouble combining the avg and collect functions as suggested in the functions list. I have…
-
making options in dropdown unavailable if selected already
How to make dropdown options become unavailable (in both forms and sheets) once they’ve already been selected. Example: If a patient books an appointment, that time slot is automatically removed or disabled so it can’t be chosen again.
-
For the Symbols Column Type, Add Grey as another Choice to Red, Yellow, Green, Blue
Currently, we can select either red, yellow, green, blue circles or red, yellow, green, grey circles as dropdown choices. However, our teams really need 5 choices, so it would be great if we could have red, yellow, green, blue, and grey as a 5 choice option.
-
Get Email from Contact Name
Formula or some option to get the email address associated with the Contact name. A name can be anything a user chooses (variable), but an email is not variable and can be used to do lookups more accurately than a name. (Relying on someone to type it in correctly is asking for trouble.) I currently use DataMesh to get the…
-
Important update for Free plan users regarding table view
Hello Smartsheet Community, We’re excited to share an update that brings you a more modern and collaborative way to work in Smartsheet—table view. Built on our next-generation platform, table view is designed from the ground up to support work management in current sheets while unlocking new capabilities now and in the…