Best Of

Re: Form has a contact list field, for the contacts are not pulling into the form

I have the same situation. Don't understand the proposed work around "...add the contacts manually to the selection list...." Is this saying we would change the column type from Contact List to a Drop Down and then add all contacts to the drop down (potentially more than 100 people)?

It seems that Smartsheet is capable of using drop-down parameters in a form, but not contact lists.

Walter2112

1 ·

Re: Form has a contact list field, for the contacts are not pulling into the form

If the form does not allow the user to select a contact from the list, but instead just saves the name, how does that impact my approval workflow when I am using the contact name from that field in my workflow automation?

Robin0618

1 ·

Re: I am looking to autotrack attendees of training sessions in MS Teams into SmartSheet

Hi @diane.reddick40501

Yes, Power Automate is an excellent solution for automatically tracking attendees from a Teams meeting into Smartsheet. Since the attendance report cannot be automatically uploaded to OneDrive or SharePoint, a workaround is to manually upload it to a designated folder, which then triggers a Power Automate flow.

Steps to Automate Attendance Tracking:

Set Up a Power Automate Flow
- Use the "When a file is created in a folder" trigger (for OneDrive or SharePoint).
- Ensure that this folder is where you upload the attendance reports manually.
Extract Attendance Data
- Since the CSV report* does not have a structured table format, use Text and Array expressions in Power Automate to split and filter relevant sections:
  - Summary (Meeting Title, Start Time, Duration, etc.)
  - Participants (Name, Email, Join Time, Leave Time, Role)
Insert Data into Smartsheet
- As @Isaac A. commented, Power Automate does have a Smartsheet connector, so once you get the necessary information from the report, you can add rows.
- Use the "Add a row" action from the Smartsheet connector.
- Map extracted fields to appropriate columns in your Smartsheet.

(*)

Additional Notes:

You don’t need to be an Office 365 Admin or a Smartsheet Admin. Being the meeting organizer or having access to the attendance report and the target Smartsheet is sufficient.
The Smartsheet connector in Power Automate allows easy row additions but does not support complex data manipulations natively—hence, parsing the CSV correctly is the most challenging step

Details of setting up Power Automate are beyond the scope of this community. However, if you need further assistance, you can contact me via email at my profile page.

Hope this helps! 😁

https://www.youtube.com/watch?v=cAczAhxgsG8

jmyzk_cloudsmart_jp

1 ·

Re: Cross sheet references not updating

I can't really help but just wanted to say I'm having the same issue. I checked for the cell size and the maximum references of 500000 or something cells but that's not the issue…

Jesse G.

1 ·

Re: Allow multiple task dates within the same row have different colors

Hello Smartsheet team,

I would like to suggest a feature that would greatly enhance the functionality of Gantt charts. Specifically, I need the ability to represent multiple phases of a project on a single row, each with its own distinct color. For example:

Phase 1: January to March (Light Blue)
Phase 2: March to June (Mid blue)
Phase 3: June to July (Navy blue)

This feature would be incredibly beneficial, especially for users managing multiple projects. I currently have a list of over 50 projects, and being able to see at a glance which phase each project is in would be a game changer for efficiency and project tracking.

I've attached an image that illustrates what this solution could look like.

Thank you for considering this idea!

Pierre Raymond

4 ·

Re: I am looking to autotrack attendees of training sessions in MS Teams into SmartSheet

Hi @diane.reddick40501!

I haven’t personally created a solution like this, but you can definitely connect Smartsheet with Microsoft Power Automate. You can check the available documentation here: Microsoft Power Automate - Smartsheet Connector to see the actions you can perform and the requirements needed to use it.

Maybe other users in the Community have done something similar, let’s see if they have any insights to share!

I hope this helps!

Cheers,
Isaac.

Isaac A.

1 ·

Card View "Levels" Options

Currently, Card View's Levels display options allow us to show Level 1/2/3 and below, which is really helpful. It would be fantastic to also have an option to display Level 1/2/3 and above, or Level 1/2/3 only. This addition would make it much easier for us to quickly provide a high-level overview of any given portfolio, without needing to create a Level helper column for filtering.

Thank you for considering this suggestion!

Laura Ablasser

1 ·

Javascript SDK with Typescript

Hi.

Many development companies that use Javascript as a backend language use Typescript to increase the readability of their code.

It would be very useful if the Javascript SDK had support for Typescript so that those of us who want to use this Javascript supplement can take advantage of all its benefits.

Right now if I work with Typescript I am forced to make API calls without using the SDK.

Thanks