-
Identifying a risk in my project plan.
I have a risk sheet with a system generated id column (ACT-0001); etc. In the risk sheet I have a helper column to identify if the risk is linked to a task in my project plan sheet. In my project plan sheet, I have a column called RiskID that contains a string of risks (ACT-001; ACT-0002; etc.) linked to a task. The risks…
-
Stopwatch Style Time Tracker
I believe the community has been looking for a solution for years. I have successfully created a way to have Stopwatch Style Time Tracking – On any sheet, at the parent or child row, by individual, and allowing manual edits! This is without using Resource Management. I used Bridge to handle the automation and two sheets…
-
Where did the certifications go? (Sys Admin, Core, Product etc)
Hi. I was going to purchase Sys Admin certification to take this morning and to my surprise lots of Certs are retired now from purchasing (Sys Admin, Core, Product, Blueprint). Where can I see official information of what's happening and what the new certifications are or plans so I can continue on my path in Smartsheet?…
-
Pull FROM Reference Link
Dear Community, i have a question, is there anyway to pull the Form link automatic into a sheet or call it by API? Of course i understand that is i have multiple Forms in One Sheet i have multiple adress Like Sheet 1 Adress 78654654 Form A — 4788 Form B — 47654 Is there any logic in the adress so we can match it and pull?
-
Split Multiple Selections In Single Form Into Individual Rows (Core Product)
There have been a number of people asking how to make multiple selections in a single form and then have those selections broken down into individual rows, and the previous answer was always to use a 3rd party app, a premium add-on, or the API. Below is a set of detailed instructions on how to accomplish this within the…
-
Merge multiple columns into one
My Smartsheet has a form with form logic - users select the Team they are requesting support from, and then the logic provides the appropriate Staff column for that Team. I would like to copy the contact from these columns into the Requested EHSN Staff column on the same row. The goal is to then hide all of the separate…
-
Smartsheet API: List Users Missing Fields & 502 Error with planId Param on Business Plan
Hi all, We have an account on the Business Plan and are using the List Users API to retrieve user details. However, when we make the API call, only a few fields are returned, matching what's documented in the API docs. Additionally, when we try to use the planId query parameter, the API returns a 502 error with the…
-
Two forms in one grid with different languages: problem with dropdown list
I have a grid with two forms: one in English and one in German. The dropdown questions are working fine, but the answer options always appear in English. When I try to change the options to German, Smartsheet automatically updates the answers in the English form as well. I’ve tested this several times, and every time I…
-
What are the options for handling a 60-item questionnaire with 8 nested child questionnaires?
Hello everyone, Initially, I was assigned to work on a 37-item questionnaire (form) that included 6 nested child questionnaires, resulting in a total of 222 columns. However, as the questionnaire has expanded, the number of items has grown significantly and is now approaching Smartsheet’s column limit. Considering that we…
-
help with auto numbering my projects that have children and grandchildren
I want to assign project numbers to the main project, and then append that project number with .(letter) for the Subprojects, with Tasks still being assigned to the main project number, with the letter of the Subproject, and adding more hierarchy, such as I'd like the task to read 40.c.1, or something similar that…