-
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…
-
Index Match Help
Good afternoon, I'm trying to get my Index and Match formula to work, it was working correctly and has now broken and I'm not sure why. I Have a "Weekly Metrics" Sheet I'm Trying to pull information over to the "Weekly Metrics 2" Sheet I'm trying to get the data from Weekly Metrics to Weekly Metrics 2 by matching the dates…
-
Smartsheet for Google Docs is no longer working
This error started to appear. I've already installed and uninstalled it and it doesn't help, it's still the same thing. There was also an error on another account I have, but in this case it was related to token authorization. Is anyone having problems with this extension too? It is very important to us!
-
How do I share a folder which is located under the Sheets folder?
Although other people are able to see and access the folder, "DigitEYES", located under the Sheets folder. I am unable to give access to it to a new user. I can't find a share function anywhere.
-
List of Same Project name with unique date.
I have four column as show in table below columns. I have one text/number column two date and one duration. "I have nearly 500 projects in my database. Some of these projects share similar names, and among them, certain projects have distinct submission dates despite having the same name. I need to compile a list of…
-
Automation Workflow Not Triggering
Hello, Does anyone have any suggestions on how to fix this issue? It seems after I've entered more data in the sheet, the triggers stopped working and I'm not receiving any emails at all. I didn't change the triggers when they used to work and only entered more data in the sheet. I've also sent a ticket to Smartsheet IT…
-
How to show/convert days to weeks on project plan
Hello All, duration column circled in blue is automated as per the project setting circled in red is all manual I know weeks cant be determined from entering dates so i entered weeks manually in actual duration column and it has set the dates, but the roll up is in days is there a formula I can use on another column to…
-
Sheet Summary/Sheet Summary Reports Questions
Hi, Is it possible that if you have several dates listed in the sheet summary on a project, that those can be pulled onto the sheet summary report not in a row, but all in one column? Then you can sort by the date and it will actually make them go in order? Instead of a row of dates, it would be a sortable column of dates…