functionality

Ask a Question

Need help with creating aging buckets.Unanswered Question

Question Iris Fuentes 4 views 0 comments 0 points Started by Iris Fuentes 03/28/20 Formulas and Functions

First post 03/28/20,Last post 03/28/20
Hello, I have the following formula in excel but it did not transfer to Smartsheet. Is there a way to get this formula over? =LOOKUP(F2,{-100,7,14,21,30,45,90,180},{"0-7","7-14","14-21","21-30",&quo…
Formulas and Functions40
Iris Fuentes
Single drop down 3 selection ( open, closed, cit). How do write formula to count each in column?Unanswered Question

Question Mike Boyer 11 views 0 comments 0 points Started by Mike Boyer 03/28/20 Formulas and Functions

First post 03/28/20,Last post 03/28/20
Status - Column Heading Open - Drop Down Closed - Drop Down CIT - Drop Down Wanting to count how many "open"
Formulas and Functions110
Mike Boyer
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
nested countif with date criteriaUnanswered Question

Question Kasey Bernard 5 views 0 comments 0 points Started by Kasey Bernard 03/27/20 Formulas and Functions

First post 03/27/20,Last post 03/27/20
I'm trying to do a countif statement that checks if a request is approved or denied, and the return to work date is great than today's date. I've tried multiple ways and can't figure it out. Any ideas? https://us.v-cdn.net/6031209/uploads/…
Formulas and Functions50
Kasey Bernard
IF and HAS and OR formula combined (or alternative)Unanswered Question

Question Morgan Frost 4 views 0 comments 0 points Started by Morgan Frost 03/27/20 Formulas and Functions

First post 03/27/20,Last post 03/27/20
Formula wizards! Can you help me with this one? I have a column for Primary Team (single select) and a column for Secondary Teams (multi-select). I want to drive a report widget to include rows where a certain team, let's say "Team X…
Formulas and Functions40
Morgan Frost
I created the Coronavirus Preparedness Template Set. How can we improve it for you?Announcement

Announcement Hunter Reed 162 views 10 comments 0 points Most recent by Dave Gordon 03/27/20The New Work/Life Reality

First post 03/24/20,Last post 03/27/20
Hey everyone! I am a Product Marketing Manager at Smartsheet who helped create the Coronavirus Preparedness Template Set available on Solution Center. It’s exciting to read the feedback you’ve submitted and scroll through LinkedIn to hear …
The New Work/Life Reality16210
Hunter Reed
Formula using <>Answered Question

Answered Laurie Bearden 11 views 5 comments 0 points Most recent by Laurie Bearden 03/27/20Formulas and Functions

First post 03/27/20,Last post 03/27/20
I'm trying to create a formula that will return a red, yellow, or green ball. I saw the below formula on someone else's comment a while back, but wasn't able to find it today. Right now my formula is: =IF([Late Tasks]@row > 0.75 * [T…
Formulas and Functions115
Laurie Bearden
Scrolling a dashboard inside an iFrame on iPhone - not workingAnswered Question

Answered Dan Snodgrass 28 views 2 comments 0 points Most recent by Dan Snodgrass 03/27/20Using Smartsheet

First post 03/24/20,Last post 03/27/20
Hi, I have several dashboards (of reports) that I am embedding on our corporate public website. They operate as expected on the desktop but on the iPhone, scrolling doesn't work properly inside the iFrame. The header is supposed to freez…
Using Smartsheet282
Dan Snodgrass
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
Does COUNTIFS work with only 2 conditions?Answered Question

Answered Avantika Murthi 15 views 2 comments 0 points Most recent by Paul Newcome 03/27/20Formulas and Functions

First post 03/27/20,Last post 03/27/20
Ive been trying to add multiple conditions in to calculate some values for my Sheet Summary, but I cant seem to add more than 2 conditions. Each of them work individually & with 2 conditions, but when i add the third condition it alway…
Formulas and Functions152
Avantika Murthi
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
End of Month FunctionAccepted Answer

Accepted Answer amiller66941 9 views 7 comments 0 points Most recent by Paul Newcome 03/27/20Formulas and Functions

First post 03/26/20,Last post 03/27/20
Good afternoon all, I'm trying to figure out how to apply the =EOMONTH(A1,0) from excel into a smartsheet. Any guidance on this would be most appreciated! Thanks!
Formulas and Functions97
amiller66941
Formula for COUNTIFAccepted Answer

Accepted Answer rymurph 29 views 25 comments 0 points Most recent by Paul Newcome 03/27/20Formulas and Functions

First post 03/23/20,Last post 03/27/20
We have a form for tracking sick time. Employee must fill out the form on first day of sick. They have to fill out the same form again when they return to work. These are both tracked in the Status column (Sick and Returning). We a…
Formulas and Functions2925
rymurph
Can update requests not be combined by recipient?Accepted Answer

Accepted Answer Dustin Shuman 7 views 1 comment 0 points Most recent by Andrée Starå 03/27/20Using Smartsheet

First post 03/27/20,Last post 03/27/20
While I understand the benefits of a sheet's workflow combining multiple rows into 1 update request, if the email field for all of those rows match, is there a way to not combine and send an email per row, meaning a user may get multiple e…
Using Smartsheet71
Dustin Shuman
Managing working parent and "homeschooling"

@crystalrmorey 70 views 2 comments 2 points Most recent by @crystalrmorey 03/27/20The New Work/Life Reality

First post 03/24/20,Last post 03/27/20
As a single mom- and full-time employee, COVID-19 brought unique challenges to our household. I both wanted to keep my kid's education progressing while maintaining progress at work. I quickly realized we needed a schedule to maintain san…
The New Work/Life Reality702
@crystalrmorey
New Template Sets for these Workflow Categories! Let me know your thoughts!

Hunter Reed 14 views 0 comments 0 points Started by Hunter Reed 03/26/20 The New Work/Life Reality

First post 03/26/20,Last post 03/26/20
Hey everyone! As a Product Marketing Manager here at Smartsheet I am always thinking about how we can produce content that helps you work more efficiently. Especially now, we are producing new Template Sets that will help you and your orga…
The New Work/Life Reality140
Hunter Reed
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
Dynamics metrics across new sheetsAnswered Question

Answered BHannah 16 views 1 comment 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 03/26/20,Last post 03/26/20
Goal: create metrics for a dashboard that automatically update when new project plans are created in the same workspace. For example: KPI=Number of late deliveries across all projects at a client I can create a metrics sheet and create a …
Formulas and Functions161
BHannah
Counting people with the same email domain in a multiselect assigned to cellAnswered Question

Answered Martina Barnett 20 views 7 comments 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 03/25/20,Last post 03/26/20
Hi there I have a multiselect Assigned To column linked to a contact list. So the contacts are displayed with their full names. Email addresses are shown in the hover over menu for each contact as per usual. I want to count how many of t…
Formulas and Functions207
Martina Barnett
Workflow sending notification through Smartsheet but not email.Accepted Answer

Accepted Answer John Morgenthaler 43 views 13 comments 0 points Most recent by John Morgenthaler 03/26/20Using Smartsheet

First post 02/26/20,Last post 03/26/20
I thought based on my personal settings I can get an email notification from workflows but I do not receive one. It only comes through Smartsheet at the top right where the bell is listed. How can I get this through email? https://us.v-cdn…
Using Smartsheet4313
John Morgenthaler
Trying to count values based on variablesAccepted Answer

Accepted Answer Acorn 13 views 2 comments 0 points Most recent by Acorn 03/26/20Formulas and Functions

First post 03/26/20,Last post 03/26/20
Hi there - first question ever! Also - not great at using the right language so sorry if it's a bit confusing! I am currently trying to use a formula to count if a certain condition is met in column a - and in column b - to count it. so f…
Formulas and Functions132
Acorn
How are you using Smartsheet to help you homeschool during COVID-19 closures?

Dana Esquivel 2.6K views 12 comments 9 points Most recent by Eric Demmitt 03/26/20The New Work/Life Reality

First post 03/17/20,Last post 03/26/20
We've been celebrating the social distancing brought on by mandatory office closures and work from home has been great! Meaningless meetings have been cancelled. Chatty Kathy hasn't been stopping by our desks with distractions four times p…
The New Work/Life Reality260212
Dana Esquivel
Determining Final Approval StatusAccepted Answer

Accepted Answer Robert Francher 12 views 4 comments 0 points Most recent by Robert Francher 03/26/20Formulas and Functions

First post 03/26/20,Last post 03/26/20
I have an approval flow that can go to one of three contacts (sometimes two). I want to add a Final Status column to make it easier to count in a summary sheet and eventual put it on a dashboard. I'm trying to create a formula with the f…
Formulas and Functions124
Robert Francher
How to create 2-way sharing across sheets?Answered Question

Answered Esperanza Zagal 12 views 2 comments 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 03/25/20,Last post 03/26/20
Hi, I am trying to make certain cells accessible for 2 way sharing. Is there a function like cell-linking that is available 2-ways? There is some financial data but mostly personnel/task and resources. Thank you, Esperanza
Formulas and Functions122
Esperanza Zagal
Formula error on Duplicate date checkAccepted Answer

Accepted Answer HOFF 28 views 3 comments 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 03/23/20,Last post 03/26/20
Have found this formula in previous discussions but is unparseable. I have gone through it a couple of times and think it is down to wrongly set parentheses, or? Slutdato=enddate, Startdato=start date. Looking to flag (double booking) if s…
Formulas and Functions283
HOFF
Date updating to Next Day using Index, Match, Max, Collect FormulaAnswered Question

Answered Amy Arnold 32 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 Functions323
Amy Arnold
I am not receiving any notifications from smartsheet and in emailAccepted Answer

Accepted Answer Jeremy Espiritu 11 views 1 comment 0 points Most recent by Debbie Sawyer 03/26/20Using Smartsheet

First post 03/26/20,Last post 03/26/20
Hi, I am not receiving any notifications from smartsheet and in email even if I am making changes. Before when I made a change the smartsheet automatically send notification. Please help. Thank you Regards, Jeremy
Using Smartsheet111
Jeremy Espiritu
How can I convert YYYYMMDD to a SmartSheet date value?Accepted Answer

Accepted Answer Anirudh 16 views 2 comments 0 points Most recent by markmontour-larson102391 03/25/20Formulas and Functions

First post 03/25/20,Last post 03/25/20
I have about 2500 date values, imported from an Excel spreadsheet, in the YYYYMMDD numerical format. I would like to convert them to Smartsheet date values. Any suggestions?
Formulas and Functions162
Anirudh
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

Ask a Question

functionality

functionality

Discussion List