-
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!!
-
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 ,…
-
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…
-
When will the System support a real Sysadmin role?
Apologies if this has been asked before, but what are the plans to implement a proper System Admin role to centrally manage user access to sheets, the ability to update owners on sheets and to support Security audits etc?
-
管理者権限を付与できません
システム管理者のユーザーを、管理者権限でワークスペースに招待したのですが、閲覧者となりシートの編集を行うことができません。 ユーザー管理画面のトゥルーアップ画面では、「メンバー」の表記なのですが、シートを開いた際に「閲覧者」としてダウングレードされたと表示されます。 考えられる原因と解決方法について教えていただけませんでしょうか。