Discussion List
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…
Retrieve a Deleted Dynamic View
I'm not sure if it's possible, but I'm REALLY hoping it is! Does anyone know if there is a way to retrieve a deleted dynamic view. I know you can find deleted sheets/reports/dashboards, but can't find a way to recover a Dynamic View I accidentally deleted.
Count IFS & Contains
I'm trying to count the number of times a specific string of text is referenced in a column on another sheet. I've tried multiple ways, but it doesn't seem to come out right - =COUNTIFS({KPHI: SHP Master Patient Tracker_ProcType}, "TAVR", {KPHI: SHP Master Patient Tracker_Comp@Proc}, CONTAINS("Arrhythmia, 1st Degree AV…
Sync Outlook calendar events into Smartsheet
I am looking for an integration tool that allows outlook calendar items to sync to smartsheet and populate content. Such as an out of office calendar populating the task list with content so that individuals can easily see who is available to be assigned to the task. Another example might be integration of a client's…
Data Shuttle Import Timestamp issue
I am attempting to import data from Excel with several Date & Timestamp fields. The format in the source file is: 04/16/2024 21:17 What I get in Smart Sheet upon Import: 45371.83695601851851851851851851852 I have tried leaving the destination column as text/number, I have tried setting it to Date - no dice. The default…
Progressive totals working with column formulas.
Background: our business has Building Managers (BMs) that we provide to a multitude of our clients on a contracted hour/week basis. The BMs have a fixed weekly work hour limit of 38 hours per week. Our various clients have standard attendance hours per week that do not align with the weekly BM hour limit. This leaves us…
Counting the occurances of distinct email addresses that are unknown ahead of time...
I am trying to build a sheet to track panel scoring for an exam. So assume that the candidates name is James Kirk (kirk@starfleet.org). After 3 panelists have entered their scoring for Kirk@starfleet.org , I want it to send a notification to me. I cant hard code any email addresses because I will have new candidates all…
Is there a way to copy conditional formatting to multiple columns?
Is it possible to not bring over an entire row to another sheet?