Formulas

Ask a Question

Formula to return the logged in user

majdesber 61 views 2 comments 0 points Most recent by Kaleb Wade 03/28/20Formulas and Functions

First post 05/18/19,Last post 03/28/20
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODA…
Formulas and Functions612
majdesber
Need help with creating aging buckets.Unanswered Question

Question Iris Fuentes 5 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 Functions50
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
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
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
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
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
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
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
How to get a lookup (Vlookup or Index Match) to return multiple values?

gregoc43 276 views 8 comments 0 points Most recent by Paul Newcome 03/26/20Formulas and Functions

First post 10/23/18,Last post 03/26/20
I'm essentially trying to have one cell populate with text values from multiple different cells based on a certain criteria. What I really wish I had is a JOINIF function, if that explains my problem better. Thanks in advance!
Formulas and Functions2768
gregoc43
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
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
formula for daily countAnswered Question

Answered rymurph 13 views 3 comments 0 points Most recent by Andrée Starå 03/25/20Formulas and Functions

First post 03/25/20,Last post 03/25/20
I'm looking to count how many times "blank" occurs in the status column per date. Entries are made daily and some days have multiple entries. I would like to set up a way to get a count of number of entries per day.
Formulas and Functions133
rymurph
Time Formats - Number formats - Rethinking the UX and function

Ezra 147 views 11 comments 0 points Most recent by Maria Fernanda Lollato 03/25/20Formulas and Functions

First post 04/01/19,Last post 03/25/20
Having an entire dialog for text and number formats would make much more sense to me.. combine the currency, percentage, thousands and decimal places into it's own dialog box. We really NEED a way to save and modify the formatting of comm…
Formulas and Functions14711
Ezra
"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
formula questionAnswered Question

Answered sahilhq 10 views 3 comments 0 points Most recent by Andrée Starå 03/25/20Formulas and Functions

First post 03/25/20,Last post 03/25/20
Hi, Please can you assist with a formula for the attached image. So if the induction column has "Yes" and Presentation column has "Yes" then the complete column should state "Yes". I'd like this formula to be…
Formulas and Functions103
sahilhq
vlook upAnswered Question

Answered sahilhq 9 views 1 comment 0 points Most recent by sahilhq 03/25/20Formulas and Functions

First post 03/25/20,Last post 03/25/20
Hi, I'd like assistance in creating a vlook up formula. So I would like the sheet to vlook up and find the date of birth and postcode from a different sheet when the name matches. See attached image of how the sheet where the vlook up nee…
Formulas and Functions91
sahilhq
Datamesh - way to transfer only parent row to sheet?Answered Question

Answered KellyAnne Brophy 22 views 1 comment 0 points Most recent by Nathan Lloyd 03/25/20Premium Apps and Integrations

First post 03/18/20,Last post 03/25/20
Hi all, I'm currently experiencing an issue when I try to DataMesh a Pivot Table to an existing spreadsheet. My Pivot Table is my Source Sheet, and I use the existing spreadsheet as my Target Sheet. The Pivot Table is set up where each r…
Premium Apps and Integrations221
KellyAnne Brophy
Help with Index/Match formula

steve50951 29 views 17 comments 0 points Most recent by steve50951 03/25/20Formulas and Functions

First post 03/23/20,Last post 03/25/20
I have a checkbox column "Inv 3rd Party Vendor." I am needing to index a master sheet with all of our property names, and look to see if the "inv 3rd party Vendor" box is checked in that sheet. If it is, I need it to ch…
Formulas and Functions2917
steve50951
Nested if for FLAG columnAccepted Answer

Accepted Answer Daniel Child 23 views 2 comments 0 points Most recent by Andrée Starå 03/25/20Formulas and Functions

First post 03/24/20,Last post 03/25/20
I am trying to build a nested if for a flag column and cannot get my brain around the final piece of the statement. Basically I am trying to create a function that looks at a 3 variables: (1) Date column and if it is not blank and (2)the …
Formulas and Functions232
Daniel Child
Trying to find value textAnswered Question

Answered Shirley Vue 10 views 5 comments 0 points Most recent by Paul Newcome 03/24/20Formulas and Functions

First post 03/24/20,Last post 03/24/20
I'm generating a chart by creating a metics grid for a tracking sheet. I tried using this formula and it's giving me the response, "UNPARSEABLE." This is what I used, "=VLOOKUP( {Tracking Sheet Range 2}"Q1_2020" @c…
Formulas and Functions105
Shirley Vue
Helper columns vs #UNPARSEABLE errorAccepted Answer

Accepted Answer Stephen Wood 16 views 4 comments 0 points Most recent by Stephen Wood 03/24/20Formulas and Functions

First post 03/24/20,Last post 03/24/20
This works for me using helper columns where I do count(parent) and count(children) =IF(OR(children18 = 0, Parent18 > 0), 1, 0) If I substitute the count(children) its #UNPARSEABLE =IF(OR(count(children) = 0, Parent18 > 0), 1, 0)
Formulas and Functions164
Stephen Wood

Ask a Question

Formulas

Formulas

Discussion List