Best Of

I see the options I have and have tried a mixture of them but can't seem to make any of them work. I don't believe this is possible using Data Shuttle, I will most likely setup automation to move off anything that does not meet the criteria to remain on the open projects list. Thanks!

Unfortunately, Smartsheet's Calendar View currently does not support large or full-size image previews — any images (added as attachments or via a cell) will only appear as small thumbnails, and there's no built-in option to resize them in Calendar View.

If you need a more visual, branded calendar experience, you might consider:

Exporting Smartsheet data to a custom Power BI or Tableau calendar, where visuals can be fully customized.

Hey @NeilKY!

Let skip question 1 for a second and jump to question 2, which will help us cover question 1.

Question 2

Can I avoid having to use static column IDs if I use the code that @Brian_Richardson posted here?

Yes absolutely. He mentions that you can retrieve all of the column IDs using the Get Sheet modules. You'll be able to specify the Column Name in your code, and then have your JavaScript code use the Column Name to dynamically find the Column ID.

Step 1: We need to add a targetColumns key into your JavaScript code. This key will come from your Get Sheet module.

Step 2: Update your Get Sheet module, make sure that it retrieves all of the columns.

Step 3: Add this key into your JavaScript module.

Step 4: Update your Javascript code to use merge the userArray and the targetColumns array.

This time I added comments into the script so that it's more clear what each step does. This script expects you to provide it with a key named userArray and another key named targetColumns.

You can modify the script however you want. But currently, it expects targetColumns to contain a column named "Email Column".

The script loops over all of the users and creates a row for each user. Each row has 3 cells, for the email, firstName, and lastName.

// Key 1: userArray - contains a list of all of the users.
// Key 2: targetColumns - contains a list of all of the columns in the sheet.

// Map the column title to the column ID.
const columnMap = new Map();
targetColumns.forEach((column) => columnMap.set(column.title, column.id));

// Create an array of all of the rows that we want to write into the sheet.
const rowsToWrite = [];

// Iterate over each user, and create a row to write into the sheet for the user.
for (const user of userArray) {
  rowsToWrite.push({
    // Add this row to the bottom of the sheet.
    toBottom: true,
    cells: [
      {
        columnId: columnMap.get("Email Column"),
        value: user.email,
      },
      {
        columnId: columnMap.get("First Name Column"),
        value: user.firstName,
      },
      {
        columnId: columnMap.get("Last Name Column"),
        value: user.lastName,
      },
    ],
  });
}

// Return the payload so that we can send it to the API.
return rowsToWrite;

This script returns an array of rows, and you can send this straight to the Smartsheet API. This is what it looks like:

[
  {
    "toBottom": true,
    "cells": [
      {
        "columnId": "1000",
        "value": "email1@example.com"
      },
      {
        "columnId": "2000",
        "value": "Alice"
      },
      {
        "columnId": "3000",
        "value": "Smith"
      }
    ]
  },
  {
    "toBottom": true,
    "cells": [
      {
        "columnId": "1000",
        "value": "email2@example.com"
      },
      {
        "columnId": "2000",
        "value": "Bob"
      },
      {
        "columnId": "3000",
        "value": "Smith"
      }
    ]
  },
  {
    "toBottom": true,
    "cells": [
      {
        "columnId": "1000",
        "value": "email3@example.com"
      },
      {
        "columnId": "2000",
        "value": "Carol"
      },
      {
        "columnId": "3000",
        "value": "Smith"
      }
    ]
  }
]

Example Script

I modified the script above to provide some example data. In this script, I "hard coded" the userArray and the targetColumns with some fake data, just so that we can see exactly what the script does.

You can open an online Javascript compiler and paste the code in, to see what it does. For example, go to https://www.programiz.com/javascript/online-compiler/ and then paste in this code.

In the real script, the userArray and the targetColumns should be added as keys into this JavaScript module.

// Key 1: userArray - contains a list of all of the users.
const userArray = [
  { email: "email1@example.com", firstName: "Alice", lastName: "Smith" },
  { email: "email2@example.com", firstName: "Bob", lastName: "Smith" },
  { email: "email3@example.com", firstName: "Carol", lastName: "Smith" },
];

// Key 2: targetColumns - contains a list of all of the columns in the sheet.
const targetColumns = [
  { id: "1000", title: "Email Column" },
  { id: "2000", title: "First Name Column" },
  { id: "3000", title: "Last Name Column" },
];

// Map the column title to the column ID.
const columnMap = new Map();
targetColumns.forEach((column) => columnMap.set(column.title, column.id));

// Create an array of all of the rows that we want to write into the sheet.
const rowsToWrite = [];

// Iterate over each user, and create a row to write into the sheet for the user.
for (const user of userArray) {
  rowsToWrite.push({
    // Add this row to the bottom of the sheet.
    toBottom: true,
    cells: [
      {
        columnId: columnMap.get("Email Column"),
        value: user.email,
      },
      {
        columnId: columnMap.get("First Name Column"),
        value: user.firstName,
      },
      {
        columnId: columnMap.get("Last Name Column"),
        value: user.lastName,
      },
    ],
  });
}

// Return the payload so that we can send it to the API.
console.log(JSON.stringify(rowsToWrite));

You may not be able to answer this last question but could I just use "Array management: Extract Field from Array", for each of the fields i want in a row, then write to the sheet for each of those values in one API call?

You might be able to do this, but since you already have to use JavaScript to map the column IDs, you might as well use JavaScript to extract the user fields.

Best of luck!