-
Formula to bring dependent values
Hello Experts, I need to return a formula with Yes or No based on a sequence of current status and the preceding steps needs to be covered. The sequence is applicable as below. Pending Dependencies (F) Not Started (F) Pre Set Up (F) Set Up (F) Smoke Test (F) Smoke Test Validation (F) Full Run (F) Full Run Validation (F)…
-
Update Report with new drop-down options
This is a multi-step question. I have a Client Data sheet. One of the columns is Household Name. I'd like to be able to report various metrics at the household level - as well as the individual person level of the Household. In the screenshot, you'll see the Household Name, the Owner First Name & Owner Last Name columns.…
-
How do I get the resources from a sheet to flow to a Form?
Hello! I am trying to create an intake form for my team. I have an assigned to column on the sheet that allows me to assign based on our company directory. This does not show up in the associated Form, however. Is there a way from the Form view to allow users to select their name from the same LDAP query that the sheet…
-
入出金履歴管理の設計について
個人単位の入出金管理について、設計の相談です。 Aさん〜Gさんなど複数名の入出金を管理しており、
以下のような構成を考えています。 ・シート①：全員分の入出金履歴（1行＝1取引） https://app.smartsheet.com/b/publish?EQBCT=63bab2005ccb46e5922aac9efd9bf560 ・シート②：名簿（個人マスタ） → 名簿側で現在の残高（SUM）を確認できるようにしています。 ・レポート①：個別の入出金履歴 https://app.smartsheet.com/b/publish?EQBCT=f090df15bdae4df894da7fc4ae26dfa2…
-
Calendar View of Project Status Progression
I have been working with a colleague building out a Smartsheet to track the progress of 54 projects she’s working on. None of the projects are time dependent, but each moves through 5 phases during the course of its life-cycle. The name of each project and its status is contained within columns of the Smartsheet. Her…
-
Calendrier rapport
Bonjour, quand je crée un rapport avec toutes les dates de mes projet. Est-ce possible d'attribuer une couleur a chaque nom de projet ? merci
-
Remove links from the entire sheet
I made a copy of a sheet to test something and forgot to uncheck the option to keep the links. Now the Sheet I copied has all of the linked rows and the sheets where the data populates from now show links to the original and to my copy. Is there a way to remove the links from my copy in hopes it removes the links from the…
-
Uploaded sheet on Teams does not allow switch from grid view to card view (or other views)
Hi fellow Smartsheet users, I have an issue of changing the table view to card view after uploading the sheet in a Teams chat. On the Smartsheet website, there is an option of switching views to card view or any other views. However, this option is not available on Teams, and we had troubleshoot it for a while and to no…
-
Gantt Bar with milestone
Would be extremely helpful for high level reporting to be able to have a parent row which is showing the overall Gantt bar be able to display a child row as a milestone marker along that bar. Our project portfolio would benefit from being able to show the go-live milestone that is occurring during the project execution…
-
Add friends/coworkers within the community
I would love to be able to add and follow friends within this community- is this already possible? Does this currently exist?