-
Join us on August 13th for a free webinar, Work seamlessly with Smartsheet and Microsoft 365 integrations.
Increase productivity and real-time collaboration with our Microsoft 365 integrations.
In this webinar, we'll share how your organi…
Using Smartsheet60
Anna Mkrtchyan
-
Missed the webinar? Review the recording in the Smartsheet Learning Center.
Top 5 tips for optimizing your sheets.
Learn best practices for getting the most out of your Smartsheet, including sheet structure, collaborating in a variety of w…
Using Smartsheet246
Anna Mkrtchyan
-
Hello Experts,
I am writing a workflow to copy and paste a particular Column value from 1 sheet to another sheet. However, the workflow is copying the entire column details from the spreadsheet.
Using Smartsheet22
Tamizamuthan Vedachalam
-
Hi, I would like to build forms with default minimum and maximum values and I would like the form to send me an email only for the values which are out of range. The min and max will be mainly numbers for different equipment. If the out of…
Using Smartsheet28
Smartsheet User
-
The data type of one of my columns is repeatedly converted to a “Date” data type from a "Dropdown (Single Select)" column type. When I return the data type to a single-select checklist, it is repeatedly converted back to a date d…
Using Smartsheet5
Cara Fagerholm
-
On a sheet, when I open an attached PDF, I get a link starting with https:// to that PDF. I want to use that URL on a dashboard but when I try to use it, I get the following error.
(Image) This doesn't seem valid to me as I have no restri…
Using Smartsheet7
Kevin Smith
-
can you automate smartsheet with sharepoint?
Using Smartsheet15
Olivia Gannon
-
I'm trying to figure out a way to get the number of rows that have a date within a certain range. An example would be if I have a column with dates ranging from January 1 2020 to August 1 2020, how many of those dates fall in the month of…
Using Smartsheet7
Kevin McIntosh
-
I used to see the login history of the users in my organization. Unfortunately once I deleted a user I cannot see their login history anymore. How should I go back and retrieve the history of actual and former smartsheet users of my organi…
Using Smartsheet9
Jean-Robert Adrien
-
Very strange! The conditional formatting of one of my spreadsheets just disappeared. I open the configurator and it is empty. Some settings are being applied but most are gone!
I am the only one allowed to change and nothing has changed. I…
Using Smartsheet12
paulen
-
Hi all,
Why can't we do multiple tasks at once time: share all the sheets to one person (because can't share workspace) or to save as a new sheet to all folders/workspace?
Thank you.
Using Smartsheet6
Thao Tran Phuong
-
Hi all,
I'm just wondering why we can't share folders of workspace to collaborators. I only can share workspace or share sheets only. Some people only need to see sheets in one folder and it's really inconvenient.
Thank you.
Using Smartsheet7
Thao Tran Phuong
-
Man, this is frustrating! I've devoted a fair bit of time perusing all of the posts, but haven't been able to get this right yet.
I've created a couple of sheets to act as training examples...the main one having products in one column, an…
Using Smartsheet18
Neil Fleming
-
Hi There-
I am trying to show a bar chart with 2 data points comparing $ amount of actual to budget. The Chart is not Starting at $0 it is starting at $800K so the data looks weird.
Can I choose the scale - say my 2 data points are $…
Using Smartsheet636
Jim Schaffhausen
-
Hi-
While using the automated approval process, users are getting additional e-mail after they approve the request.
Is there a way to disable that? It just creates unnecessary e-mails and notifications serves to very little to no purpose.…
Using Smartsheet15
Enes Zorkul
-
Hi,
Are there any recommendations you can provide to using Smart Sheet and Web Form as workaround to traditional testing applications to manage repetitive testing (case management and result gathering) across multiple users performing sam…
Using Smartsheet248
irene
-
I have the honor of partnering with a number of colleagues from across the organization to bring you the "How Smartsheet uses Smartsheet" track as part of our annual Engage Conference this year! Real use cases provide so much ins…
Using Smartsheet8
elektra_h
-
Hello,
Our company is going through a name change and with this our domain is changing also. I am wondering if there is anyway that we can bulk add their email with the new domain on it as an alternate email.
Using Smartsheet7
Nick Champlin
-
I use forms for surveys a lot. I'd like to be able to use a video to ask a question. For example, if the survey is for the CEO, I'd like to video the CEO actually asking the question. Also, I'd also like to refer to graphs in my question…
Using Smartsheet10
KBeem
-
Is there a way to view previously published smartsheets? I am looking for a way to look back and see previous contents.
Using Smartsheet7
Che Fortaleza
-
For documentation purposes, I need to Cc myself on all automated alerts that are sent to a vendor to notify the vendor that a warranty claim has been assigned to them. I set up a workflow that sends an alert to each contact that is include…
Using Smartsheet8
Shelby
-
Hi there,
Is it possible to hide comments in a published report? I see this is an option when publishing a sheet as "Read only - HTML", but this option does not appear to be available when publishing a report. There are comments …
Using Smartsheet11
Jamie Bedford
-
I can not even see what the header in the third column says. I know it says CM Help Needed. All I can see is part of the N and the eeded. How do I fix this without making the column super-wide? (that would waste a lot of space)
I tried t…
Using Smartsheet8
Marc Lajoie
-
Hi. I'm sending a link to my report in an automated workflow as an "Alert Someone". The recipient email contains a link to the report and a snapshot of the report, but it is limited to 100 rows. A message appears at the bottom t…
Using Smartsheet7
Sandra Dye
-
Hi Community,
Many moons ago, I stumbled upon Smartsheet collateral that could be downloaded for use in Dashboards/Portals. Specifically, it was things link artistically designed lines that could break up a Dashboard page, and other simil…
Using Smartsheet11
Ken Hankoff
-
I'm trying to do a count if criteria within two columns meet particular criteria. I keep getting the unparseable error message. My formula is:
=COUNTIFS({NCO-SD Intake Range 1}, [Contact Email]7, AND{NCO-SD Intake Range 2}, [Assigned Total…
Using Smartsheet8
Carlos Yanes
-
Is there a formula that would bring back multiple cell values within a column, if there are two specific conditions being met? For example, I have a list of users that are working on tasks that are listed in each cell. I'm wanting to bring…
Using Smartsheet9
Carlos Yanes
-
Greetings my Smartsheeters-in-crime,
And Happy Friday, all.
Random question of the day here
We have 60 product managers here all working off of a shared roadmap.
I built a report, then modified it (yes, 60 times) for each of the product m…
Using Smartsheet8
Alan Rappa
-
Is there a way to set sheets to auto refresh? I have several reports set up for sheets, but will not refresh unless done manually.
Also, when sheet B is updated from data entry from sheet A, conditional formatting does not update on shee…
Using Smartsheet6
Emerus CCC
-
Hi Community,
I've started a Software Issue tracker and so far I've found ways to display the information how I'd like it. I hit a road block when trying to display the latest comment a field on the spreadsheet.
I'd still like to use t…
Using Smartsheet216
Juston Oakes
-
Is it possible to reference the latest comment on a row, in a cell?
And if we cannot currently do so, could this be considered an additional feature in the future? I would love to see the latest "update" on a project task as opp…
Using Smartsheet423
@daniel
