-
Automation help or formula for connecting rows
AW Placement request form below takes in all of the school placement requests via a form. Once the column AW REQUEST STATUS is 'approved by leader' it is automatically moved to Students/Instructors - AWI The ANCHOR ID transfers over from AW placement request sheet to students\instructors - AWI - when approved by leader…
-
Dashboard issue
Hello there I have an issue when i create a dashboard, the colors of the cells disappear when i save the file as pdf. I use Smartsheet for KPIS and it shows the color of the percentages result as i set it up in different colors based on the performance, but when i save the fil all the colors disappear. Please see the…
-
Recent errors from Control Center - cant update a cell
I've browsed through other posts and found similar info and solutions to look into, but wanted to see if this was unique, or result of a recent change on Smartsheet end. Our template has been in place for a few years now. No changes to the cells now throwing errors, and no changes to the sheets that should impact these…
-
I don't know why some managed resources are not appearing in the project resource overview
I keep getting the same message asking to 'save the sheet and reopen the panel' to see the resource updates for a particular person(s), but they still don't appear in the resource overview, once I've expanded the section, after following the instructions. Any help would be much appreciated. Also, I am integrating my teams…
-
PowerApps, Azure and Varicent Integration
Has anyone been able to automate regular feeds and delta record changes from PowerApps, Azure or Varicent?
-
Project Managment Office - Intake Sheet Issues - Added Multiple Project Metadata Links
We have an issue with our project intake sheet. The links to the project metadata sheet now have many project metadata links and data is not connecting properly (see screen shot below). I believe we need to repoint each entry to the right metadata sheet manually then repoint future entries to the template metadata sheet.…
-
Smartsheet-Jira Integration not synching assignee & date field
We have a few workflows where 11 fields are setup to synch between Smartsheet & Jira. The fields synching correctly include: Issue Key, Summary, Type, Status, Priority, Label, Start & Stop dates. However, the "Assigned to" (contacts, unrestricted) and a "Trend Start Date" & "Due Date" (both are date field, unrestricted)…
-
Resource Management - Work Item name not displayed in the Time and Expenses
Hello everyone, I am asking about a feature in RM that is confusing for me and my customers. Work Items listed in the Project Schedule / Work List (either retrieved from the activities / tasks from a Smartsheet's sheet) are not displayed in the Time and Expenses section of a person' Page. We have them in the Today's view,…
-
CORS interruption while fetching Smartsheet API
We want to use simple fetch to GET request the data from our Smartsheet instead to the Smartsheet JS SDK. The code snippet is as follows : This JS file has been linked to a HTML file which is being fired up on the browser using Live Server extension available in VsCode. But upon checking the console on the browser (all…
-
SCIM Provisioning Issues
We're using AzureAD and are using an expression to map the value to urn:ietf:params:scim:schemas:extension:enterprise:2.0:User:department Expression: Join("-", "", CStr([departmentNumber]), [department]) Output Exampe: 00-Department Error: Failed to update User 'xxx@xxx.com' in customappsso; Error: StatusCode: BadRequest…