Last month, we asked you to share something you would try if you knew you couldn’t fail, and the responses showcased the beautiful diversity of our Community. As some of you pointed out, failure is an important part of learning and improving, but it’s still amazing to know what you would pursue if that wasn’t a concern. I…

Clap your hands and say yeah for our May Member Spotlight and Community Champion, @Paul McGuinness! Paul lives in the Greater Colchester area in the United Kingdom and works as a Central Operations Manager at Care UK. He also just got back from ENGAGE London, but we’ll get to that in just a moment! His meet-cute story with…

Are you a passionate Smartsheet Gov evangelist? Unlock exclusive resources as a Mobilizer! Once you join, you'll get a number of resources that can help grow the usage of Smartsheet Gov within your agency: Access to a Mobilizer Portal with tools designed to help you share information with leadership or peers, expand usage,…

It's almost time! Rumor has it that annual applications for Smartsheet Overachievers are opening very, very soon. Learn more about the program here Share the excitement on LinkedIn Or tag someone in the comments below that YOU think should apply (no judgement if you tag yourself) 😉 More to come!

Hi Community, We are excited to share that Dynamic View is now available through the Smartsheet Gov environment! Dynamic View provides users with simple views into process execution status – leading to increased visibility and insights. It also enables collaboration while maintaining confidentiality of process at scale.…

I have tried to follow other threads asking similar questions, but I'll admit, I'm lost and any attempt at following those formulas has not resulted in what I need! We currently have a request form and have each submission set to assign an auto number to the request. Which is ok, but we really don't want them to be…

Team, I am trying to work out a formula that states the following: If the WF Open Deadline - Facility Handoff Date is less than 5 days then Green If the WF Open Deadline - Facility Handoff Date is at than 5 days then Yellow If the WF Open Deadline - Facility Handoff Date is greater than 5 days then Red If the Facility…

I feel like I am getting close to this one, but something is still not working out. I just want a simple Pie Chart to show total Complete Vs. Total Incomplete. I have tried using several different columns and strategies, and although this should be easy, it is not clicking… Here is how I have it displayed now… and also a…

I'm trying to get a rolling 4 (and rolling 13) average for these conversion metrics that I track weekly. Can I capture that data across a row, rather than within a column? Here's a screenshot of a basic average formula for the past 4 weeks. But what I'd like is for the average to automatically calculate the last 4 weeks…

Hello! I hope someone can help or provide any insight. We have implemented a sheet to review tickets using a smartsheet form. The tickets are categorized in 2 (lets say "Category A" and "Category B"), so each category has different options to review and the form has a logic depending on the category are the options…

Encountering the following problem: "The EntityID associated with this IDP is already in use. Please select a unique EntityID for your setup." Even though we're using a different IDP, the problem persists.

This discussion was created from comments split from: Attach File or URL to Row - Request Body for cURL or Python.

Hello, I'm having issues showing data labels on a stacked bar graph. I can get the labels to appear on a regular bar graph (left) but when I stack them (right), I only get data labels for the last row. Any idea why this is happening? I thought it was only showing positive %s but noticed there would be a 10% in the middle…

=IF(ISBLANK[Date Filled]@row), [Date of Vacancy]@row - Today@row, [Date Filled]@row-[Date of Vacancy]@row) I keep getting the #UNPARSEABLE error and I can't seem to figure out why. Any help would be greatly appreciated.

Hello! I hope someone can help or provide any insight. We have implemented a sheet to review tickets using a smartsheet form. The tickets are categorized in 2 (lets say "Category A" and "Category B"), so each category has different options to review and the form has a logic depending on the category are the options…

Last month, we asked you to share something you would try if you knew you couldn’t fail, and the responses showcased the beautiful diversity of our Community. As some of you pointed out, failure is an important part of learning and improving, but it’s still amazing to know what you would pursue if that wasn’t a concern. I…

Clap your hands and say yeah for our May Member Spotlight and Community Champion, @Paul McGuinness! Paul lives in the Greater Colchester area in the United Kingdom and works as a Central Operations Manager at Care UK. He also just got back from ENGAGE London, but we’ll get to that in just a moment! His meet-cute story with…

Are you a passionate Smartsheet Gov evangelist? Unlock exclusive resources as a Mobilizer! Once you join, you'll get a number of resources that can help grow the usage of Smartsheet Gov within your agency: Access to a Mobilizer Portal with tools designed to help you share information with leadership or peers, expand usage,…

It's almost time! Rumor has it that annual applications for Smartsheet Overachievers are opening very, very soon. Learn more about the program here Share the excitement on LinkedIn Or tag someone in the comments below that YOU think should apply (no judgement if you tag yourself) 😉 More to come!

Hi Community, We are excited to share that Dynamic View is now available through the Smartsheet Gov environment! Dynamic View provides users with simple views into process execution status – leading to increased visibility and insights. It also enables collaboration while maintaining confidentiality of process at scale.…

Hello! This is a space for Smartsheet and Smartsheet Gov users that work in all levels of government to connect, share ideas, challenges, best practices and how you are using Smartsheet and Smartsheet Gov to create impact. My name is Chris, I lead marketing for the Smartsheet Gov platform and am excited to get to know you…

Hi Community, Studies have consistently highlighted the vulnerabilities of password-based systems, including susceptibility to brute force attacks, phishing, and password theft. Such risks not only jeopardize data integrity but can lead to severe repercussions. As a part of our ongoing commitment to enhancing the security…

Thank you so much to everyone who attended ENGAGE London last week! Whether you were there in person or cheering from home, here's a nice roundup of the highlights from the big event. 👉🏻 Read the full blog post or watch the Opening Keynote below I want to give a special shoutout to our Overachievers, Community Champions…

Are you attending Smartsheet Gov Forum, the inaugural customer event for users of the Smartsheet Gov platform? Let us know! Introduce yourselves and get a head start on your engagement and networking! Not registered yet? Sign up while there’s still space available to come sharpen your skill set, deep dive into the…

Hello Smartsheet Community, We’re proud to share that Smartsheet has achieved a milestone of $1B in annualized recurring revenue. Many of you have been with Smartsheet for many years, seeing the product expand and evolve. From modest beginnings, Smartsheet has pioneered the enterprise work management category – now working…

I have tried to follow other threads asking similar questions, but I'll admit, I'm lost and any attempt at following those formulas has not resulted in what I need! We currently have a request form and have each submission set to assign an auto number to the request. Which is ok, but we really don't want them to be…

Team, I am trying to work out a formula that states the following: If the WF Open Deadline - Facility Handoff Date is less than 5 days then Green If the WF Open Deadline - Facility Handoff Date is at than 5 days then Yellow If the WF Open Deadline - Facility Handoff Date is greater than 5 days then Red If the Facility…

I feel like I am getting close to this one, but something is still not working out. I just want a simple Pie Chart to show total Complete Vs. Total Incomplete. I have tried using several different columns and strategies, and although this should be easy, it is not clicking… Here is how I have it displayed now… and also a…

I'm trying to get a rolling 4 (and rolling 13) average for these conversion metrics that I track weekly. Can I capture that data across a row, rather than within a column? Here's a screenshot of a basic average formula for the past 4 weeks. But what I'd like is for the average to automatically calculate the last 4 weeks…

Hello! I hope someone can help or provide any insight. We have implemented a sheet to review tickets using a smartsheet form. The tickets are categorized in 2 (lets say "Category A" and "Category B"), so each category has different options to review and the form has a logic depending on the category are the options…

I have a form that includes the option to add an attachment. We have automation set up to email the submission, however whenever there is an attachment uploaded in the form, the email only shows the link to the attachment, is there a way to set up the automation to send the actual attached file and not a link? Thank you

We have a large field team with a hierarchical organization. Usually the guys at the bottom are submitting forms which are basically project requests. They access these forms through shortcuts on a published dashboard. We have a required contact field in the form for them to select their name and their supervisors' names.…

I have a document that need to be inserted by format every 30 minutes, I want other document where I can see all days of the year with the rage of time , I just need to know if the information was inserted or they missed This document is where the operator inserted the information the next document is what I need to see if…

Encountering the following problem: "The EntityID associated with this IDP is already in use. Please select a unique EntityID for your setup." Even though we're using a different IDP, the problem persists.

Hi, I have a Smartsheet that has IOKR's in it (initiative, object, key result) that is not using parent / child rows. Is it possible to create a formula that gives me the health of initiatives based upon the health of the objectives which is based on the health of the key results? One initiative may have multiple…