-
How to replace a contact name using a formula
I have a Control Center program that creates a project management sheet for each new project. In the Intake Sheet we have a contact column "Project Manager" where Control Center pre-populates the project manager's contact name in every row, of the project, where the project manager oversees the task associated with that…
-
How to add Developer Tools to GOV account?
Hi, I want to add Develope Tools to a GOV account so I can than Create New App which will help me in generating a ClientID and ClientSecret. I need those to give users a log in page. I am able to create developers account for non gov account, but not for gov. Please help with steps for developers gov account. Thanks
-
Can a form open the Smartsheet Contacts List like the sheet does on a contact list field?
When a Contact List column type is used in a sheet, the dropdown arrow opens the Smartsheet Contacts List to choose the relevant person. The form uses email validation on that same field but it doesn't open the Smartsheet Contacts List like the sheet. The email validation requires the form user to type a valid email…
-
Regional date format issue in cross sheet reference
Hi, we use control center to roll out project toolkits, the intake sheet includes a start and end date for contracts. These dates pull through to a metadata sheet then to various other assets in the toolkit. To set up I right click the cell and select 'Link from cell in other sheet' and link to the relevant cell in the…
-
Updating template -> updates sheets made from the template
I would love to have the ability to make a change to a template that I created and be given the opportunity to select sheets that were created from that specific template to automatically update as well. For context: I keep track of ~130 employees training records. Each employee has their own separate sheet with all of the…
-
Extraer la Hora de 2 o mas celdas
Buenas tardes, como podria extraer la hora de registro de 2 ó mas celdas? o como podria registrar la Hora en una celda?
-
Protect formulas within cells in a single column without using column formula or locking the column
Objective: Status column is a drop-down. The cells in the Status column have a formula using Descendants, with the idea that when the descendants tasks are all marked with the same status, such as "Completed," then the ancestor to those descendants is also auto-marked as "Completed." Example: See screenshot below. When…
-
Date/Time field should be Date&Time field
Timestamps are only included on Created Date and Modified Date but it is useful to have a specific timestamp that will not update every time the row/sheet is modified. This would be a huge help especially when using the Duration field or other formulas. Either update the Date/Time field to include the time like Created…
-
Dashboard Pie Charts
I have a dashboard created to track how my employees are doing with completing their assigned trainings. I use Pie Charts/Donut Charts to track the number and percentage of completion and these link to the reports I use for the information. I want to be able to change the colors of the default blues to red and green so…
-
Access to Smartsheet University - HELP No longer there
Hello - This morning when trying to go to Smart sheet University, my peer and I clicked on "help" and nothing happens. It was working fine Friday, but no longer working today. Can't get to help or Smartsheet University. Anyone else having this issue? Used in Chrome and Edge browsers