Sheets

Ask a Question

Can I turn off the "Used in formula on" information screen?Accepted Answer

Accepted Answer Sonny Mendoza 10 views 3 comments 0 points Most recent by Andrée Starå 03/27/20Formulas and Functions

First post 03/27/20,Last post 03/27/20
I have linked many sheets so now when I try and select a drop down within a cell I cannot because this "Used in formula on" window hovers over my select options. Is there a way that I can turn this off?
Formulas and Functions103
Sonny Mendoza
Reporting on who and how many times an individual has attended eventsAnswered Question

Answered Melissa P-B 42 views 19 comments 0 points Most recent by Paul Newcome 03/27/20Formulas and Functions

First post 03/12/20,Last post 03/27/20
Greeting all. I am my wits end on this one because I'm pretty sure this can be done but I'm not quite finding out how. The problem I'm trying to solve is as follows: We manage multiple events in Smartsheet. We use forms for sign ups so all…
Formulas and Functions4219
Melissa P-B
Protecting Folders From Admins In WorkspaceAnswered Question

Answered Jonathan Forrester 9 views 2 comments 0 points Most recent by Paul Newcome 03/27/20Using Smartsheet

First post 03/27/20,Last post 03/27/20
I have template folders in a Workspace that either gets edited or deleted by Admins. I cant make them editors because then they cannot make folders and edit other documents that they need to work with. Is there a way to make it so certain …
Using Smartsheet92
Jonathan Forrester
Populating a Multi-Select Column from Excel

TeriOWY 9 views 0 comments 0 points Started by TeriOWY 03/26/20 Using Smartsheet

First post 03/26/20,Last post 03/26/20
I am trying to pull my data from Excel into Smartsheet and have it to have multi-select columns. I am attaching my Word doc with the descriptions and images to explain. I cannot figure out how to get that document to post nicely in this w…
Using Smartsheet90
TeriOWY
Document the value of function / calculated field every dayAccepted Answer

Accepted Answer Stefan Milic 18 views 3 comments 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 03/26/20,Last post 03/26/20
Hi all, I have 2 sheets: 1) working sheet where all tickets are logged + their status is maintained 2) calculation sheet with fields showing e.g. number of open / closed tickets and so on (calculated by formulas which refer to the working…
Formulas and Functions183
Stefan Milic
Automatic sorting

lisa.nichols43261 794 views 23 comments 0 points Most recent by Preston Plambeck 03/26/20Using Smartsheet

First post 04/03/18,Last post 03/26/20
i have a sheet that has data with dates added from a form. it always adds a new request from the form to the top and i have to manually sort it by date in descending. is there not a way to have it automatically add the data by the date in …
Using Smartsheet79423
lisa.nichols43261
Date updating to Next Day using Index, Match, Max, Collect FormulaAnswered Question

Answered Amy Arnold 31 views 3 comments 0 points Most recent by Debbie Sawyer 03/26/20Formulas and Functions

First post 03/20/20,Last post 03/26/20
Hi, I'm working with two Smartsheets. (1) One sheet collects the data from a Smartsheet form. I added two columns to this sheet using the Auto-Number/System Feature (under Edit Column Properties). This features stamps new row entries wit…
Formulas and Functions313
Amy Arnold
Managing and Reporting on Multiple Projects EffectivelyAnswered Question

Answered Rob Ford 44 views 1 comment 0 points Most recent by Debbie Sawyer 03/25/20Using Smartsheet

First post 03/23/20,Last post 03/25/20
I apologize for the length of my post, but I want to be thorough in describing what I would like to do and what I’ve already tried. I’ve also searched through help and the forums, and I either haven’t found a solution or am too hyperfocuse…
Using Smartsheet441
Rob Ford
Chart budget vs actualAnswered Question

Answered Laura Corredor 13 views 2 comments 0 points Most recent by Laura Corredor 03/25/20Using Smartsheet

First post 03/25/20,Last post 03/25/20
Hello, I have a sheet where I can see budget, actual and variance for my project budget. So column 1 is january budget, column 2 january actual and column 3 january variance, and so on. All I want to is to create a line-type chart for my d…
Using Smartsheet132
Laura Corredor
"Save As New" Not Preserving Cross-ReferencesAccepted Answer

Accepted Answer Rachel Peabody 17 views 7 comments 0 points Most recent by Paul Newcome 03/25/20Using Smartsheet

First post 03/19/20,Last post 03/25/20
Hello, I'm building a sheet in which I'm using lots of cross-references in the sheet summary. I plan to use it as an active metric field to display summary information from data in other sheets. I will need to copy the sheet about 30 times…
Using Smartsheet177
Rachel Peabody
ODBC data pulls US date to mail mergeAccepted Answer

Accepted Answer PeterR 15 views 1 comment 0 points Most recent by Nathan Lloyd 03/25/20Using Smartsheet

First post 03/23/20,Last post 03/25/20
I am pulling information into a Microsoft Publisher label template from Smartsheet using ODBC smartsheet live data connector - this all works fine but any columns that are formatted in smartsheet as date columns are switched from UK format…
Using Smartsheet151
PeterR
Is there a way to deal with "maybe situations" or varying predecessors?Answered Question

Answered Zoe Charalambous 25 views 1 comment 0 points Most recent by Alejandra 03/24/20Using Smartsheet

First post 03/19/20,Last post 03/24/20
Hi SmartSheet community! This may be an odd one to describe but I am going to try my best. I have a process that is a bit circular and is also a "maybe situation." For our product, we will go through rounds of optimization but o…
Using Smartsheet251
Zoe Charalambous
Form Issue: Auto-Complete Contact Column

Connor Hartford 51 views 3 comments 0 points Most recent by Jennifer Belawski 03/24/20Using Smartsheet

First post 08/23/19,Last post 03/24/20
Hi All, I think this feature should be a part of the Smartsheet web client, however, it is not. BUT it is a part of the mobile app. When I go to type someone's name into a contact column field USING A FORM, it won't auto complete and sh…
Using Smartsheet513
Connor Hartford
Collaborator Name not Recognised When Trying to Apply a Filter in Activity LogAccepted Answer

Accepted Answer Steve Bertram 17 views 2 comments 0 points Most recent by Steve Bertram 03/23/20Using Smartsheet

First post 03/19/20,Last post 03/23/20
Hi, when looking at the activity log for one of my sheets I can see the names of the collaborators the sheet has been shared to. However, when I try to filter on one of the collaborators I'm met with the error message "Unknown User En…
Using Smartsheet172
Steve Bertram
Can Formulas Reference Reports?

UnaB 274 views 11 comments 0 points Most recent by Paul Newcome 03/23/20Formulas and Functions

First post 11/20/18,Last post 03/23/20
I'm trying to see if formulas can reference reports or just root SS. I ran a report for all late tasks assigned to all people in a department. I then wanted to use a COUNTIF formula that would sum up all the late tasks of a certain person.…
Formulas and Functions27411
UnaB
Verify All Sites Submitted Response TodayAnswered Question

Answered Amy Arnold 14 views 1 comment 0 points Most recent by Genevieve P 03/23/20Formulas and Functions

First post 03/19/20,Last post 03/23/20
Hi, I'm trying to track if a site (or Name) created a new daily entry using a Smartsheet form. I added this formula to the Updated Today column to return a "Yes" answer if the site (or Name) created a new daily entry. This seems…
Formulas and Functions141
Amy Arnold
Hidden Columns in Reports - edit, print, send dialoguesAccepted Answer

Accepted Answer DJB 13 views 3 comments 0 points Most recent by Andrée Starå 03/21/20Using Smartsheet

First post 03/21/20,Last post 03/21/20
Hi. i have built some reports off a large sheet where i have chosen to show only select columns related to the function of the report. I have also hidden some columns within the report. Yet when i use the Edit, Print, or Send dialogue boxe…
Using Smartsheet133
DJB
Counting physical inventory while removing duplication...Answered Question

Answered Drew Frazelle 35 views 4 comments 1 point Most recent by Andrée Starå 03/21/20Formulas and Functions

First post 02/14/20,Last post 03/21/20
I'm trying to count the number of unique pieces of equipment that are on my worksite. Each unit has a specific Unit Number listed in a sheet. Units that are On-Site are indicated by a green dot in another column. The tricky part for me is,…
Formulas and Functions354
Drew Frazelle
How to ensure data privacy?Answered Question

Answered [email protected] 15 views 1 comment 0 points Most recent by Andrée Starå 03/21/20Using Smartsheet

First post 03/21/20,Last post 03/21/20
Hi I want some of my users to be able to submit data using forms. But in order to be able to fill out a form, the users must have shared access to the sheet that contains the input form in question. With sheet sharing enabled, the users …
Using Smartsheet151
[email protected]
Tracking rows from other sheetsAccepted Answer

Accepted Answer xav 20 views 4 comments 0 points Most recent by Andrée Starå 03/18/20Formulas and Functions

First post 03/17/20,Last post 03/18/20
Hi everybody I have several rows from different sheets that feed my master sheet via "move row" automation. I need to track in a column on my master sheet which row is coming from which sheet. The only approach I can think of is…
Formulas and Functions204
xav
System generated Created (Date) column keeps changing itself to regular Date column.Answered Question

Answered Nicole Campbell 20 views 4 comments 0 points Most recent by Andrée Starå 03/17/20Using Smartsheet

First post 03/11/20,Last post 03/17/20
I have a column that I'm setting to the type of Auto-Number/System that I'm setting to Created (Date). Some time later, it changes itself back to a regular Date column. I've re-set it numerous times and it keeps happening. Each time, I …
Using Smartsheet204
Nicole Campbell
Auto Delete rows

Tal Segal 189 views 7 comments 2 points Most recent by lea montfajon 03/16/20Using Smartsheet

First post 07/13/18,Last post 03/16/20
HI, I would like to know please what will be the best way to delete rows which their time stamp i more than 24 hours. i can't find a delete function under the conditionl function.
Using Smartsheet1897
Tal Segal
Seven Most Current Entries for each Question for Each LocationAnswered Question

Answered Amy Arnold 25 views 4 comments 0 points Most recent by Paul Newcome 03/16/20Formulas and Functions

First post 03/15/20,Last post 03/16/20
Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. https://us.v-cdn.net/6031209/uploads/745/RJB22XU6CD5F.png This is the formula I started using based on responses in the c…
Formulas and Functions254
Amy Arnold
Any templates or sample of multiple project dashboards?

Fairorth 124 views 6 comments 0 points Most recent by Paul Newcome 03/16/20Using Smartsheet

First post 12/06/19,Last post 03/16/20
Our small company does several projects at a time and all of them basically follow the same project plan. We created a nice template that contains the dozen or so tasks in our project. Most of the reports and dashboards I've tried to crea…
Using Smartsheet1246
Fairorth
Counting completion status off of a group of sheetsAnswered Question

Answered Mike Wilday 16 views 3 comments 0 points Most recent by Genevieve P 03/12/20Formulas and Functions

First post 03/11/20,Last post 03/12/20
We started a new process for course development that has tracking development of each of our courses in separate sheets. 1 course per sheet. Its easy to pull a report of how many of those courses are now in a complete status but I am tryin…
Formulas and Functions163
Mike Wilday
Presenting attachments on a report widget in a dashboard

mikoker 251 views 11 comments 0 points Most recent by Andrée Starå 03/12/20Using Smartsheet

First post 04/12/19,Last post 03/12/20
I'm looking for a way to present attachments when placing a report widget on a dashboard. It looks as if this column is not presented although it is on the source report. Anyone with a suggestion on how to do that?
Using Smartsheet25111
mikoker
Notification with Attachments

katherinehall 153 views 11 comments 0 points Most recent by Andrée Starå 03/12/20API & Developers

First post 02/01/19,Last post 03/12/20
Hi there, I would like to send a notification with an attachment based of a status change. The notification works, but doesn't include the attachment. I have seen on the community that this is not possible in SS - is this still true? If…
API & Developers15311
katherinehall
Multiple Notifications/Emails for single workflow

TrishLD 100 views 6 comments 0 points Most recent by Andrée Starå 03/12/20Using Smartsheet

First post 06/10/19,Last post 03/12/20
I put together a workflow that sends an email for approval, however whenever the project is approved it email blasts the contact who made the request (sends out like 7 emails/notifications) that all say the same thing. Is there a way to o…
Using Smartsheet1006
TrishLD
Proofing - Office Documents

Michael Lockwood 83 views 6 comments 0 points Most recent by Shannon Heizenrader 03/10/20Using Smartsheet

First post 10/14/19,Last post 03/10/20
Is there a plan to include Office documents such as Word Docs or PowerPoints into the functionality of proofing without having to convert them to PDF for uploading them?
Using Smartsheet836
Michael Lockwood
Is it possible to copy an automation workflow from one sheet to another sheet?

sdonnelly 83 views 5 comments 2 points Most recent by Andrée Starå 03/10/20Using Smartsheet

First post 01/22/20,Last post 03/10/20
I have an automation workflow in one sheet that I want to use in a different sheet. Is there a way to copy this workflow and then add it to my other sheet (similar to how you can copy summary reports from sheet to sheet)? Or do I need t…
Using Smartsheet835
sdonnelly

Ask a Question

Sheets

Sheets

Discussion List