Formulas and Functions

Drop down selections not appearing in formUnanswered Question

Question Christina Riot 3 views 0 comments 0 points Started by Christina Riot 03/28/20

First post 03/28/20,Last post 03/28/20
Is there a know issue with this or is there a max number of selections with forms? I have a contact list of 3000 names and it is not appearing as a drop down in my form. Other drop down's I have are indeed showing up and I am doing nothi…
Formulas and Functions30
Christina Riot
Formula to return the logged in user

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

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
Logic and summaryUnanswered Question

Question dave.mcpherson56751 8 views 0 comments 0 points Started by dave.mcpherson56751 03/28/20

First post 03/28/20,Last post 03/28/20
Hi, We have 400 locations managed by approx 30 managers. I am trying to use logic to build a form that when manager 1 chooses their name they only see sites relating to them. To achieve this i have created columns with a drop down for eac…
Formulas and Functions80
dave.mcpherson56751
How can I have a parent card marked as "Done" if all their sub-tasks are completeAccepted Answer

Accepted Answer Daniella Canada 19 views 2 comments 0 points Most recent by Daniel Hampshire 03/28/20

First post 03/18/20,Last post 03/28/20
We are using the card view to provide use case testing for our clients. Currently, the sub-tasks roll up to a parent row which makes the card. However, when sub-tasks are marked done (using the checkbox functionality in cards), I can't fig…
Formulas and Functions192
Daniella Canada
Need help with creating aging buckets.Unanswered Question

Question Iris Fuentes 5 views 0 comments 0 points Started by Iris Fuentes 03/28/20

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

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
Is there a way to have a contingent question on a form?Answered Question

Answered Kendra Roach 10 views 1 comment 0 points Most recent by Andrée Starå 03/27/20

First post 03/27/20,Last post 03/27/20
I am wondering if I can have a secondary question become "live" on a form based on an answer to a question?
Formulas and Functions101
Kendra Roach
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/20

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

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
Average if contains a specific wordAccepted Answer

Accepted Answer Sylvia Elizabeth 14 views 6 comments 0 points Most recent by Sylvia Elizabeth 03/27/20

First post 03/20/20,Last post 03/27/20
Hi! I'm trying to type a formula which could tell me the percentaje of the cells that are in color green, those cells are painted in green when I type the word "Listo", so I found that formula (showed in the image) in the communi…
Formulas and Functions146
Sylvia Elizabeth
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

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
Data Uploader - if value exists on input file, need it to update status field on source sheetAccepted Answer

Accepted Answer Christina Reid 29 views 4 comments 0 points Most recent by Christina Reid 03/27/20

First post 03/12/20,Last post 03/27/20
We have tracking sheet that we use to track client accounts that are transferring. I want to take a different file that shows accounts that have confirmed been transfer and use Data Uploader to have the information on the input sheet eith…
Formulas and Functions294
Christina Reid
Formula using <>Answered Question

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

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
Range with multiple columns with COUNTIFSAnswered Question

Answered Al ISS 11 views 1 comment 0 points Most recent by Paul Newcome 03/27/20

First post 03/27/20,Last post 03/27/20
One range in my COUNTIFS formula has several columns included. If I use this range on COUNTIF (no S on it), it works perfectly but, when I include in COUNTIFS, it does not work. (#Incorrect Argument Set). I then split all these columns in …
Formulas and Functions111
Al ISS
Need to create a "shift" column from a time columnAnswered Question

Answered Mommaduck 17 views 10 comments 0 points Most recent by Paul Newcome 03/27/20

First post 03/26/20,Last post 03/27/20
I have a column with the time (hh:mm) an interaction took place. I have another (currently blank) column for shift that I need to populate from the time. The "shift" during which an interaction took place would be: 7Am-12:59…
Formulas and Functions1710
Mommaduck
Help with cross sheet references.Unanswered Question

Question Dave Moe 9 views 0 comments 0 points Started by Dave Moe 03/27/20

First post 03/27/20,Last post 03/27/20
Good morning, I am looking to pull the data in a cell if two other criteria are met in other cells in the same row. for example, I have a sheet called Daily reporting that is receiving form submissions. I want to pull the text in [Qualit…
Formulas and Functions90
Dave Moe
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/20

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
IF Formula IssueAnswered Question

Answered NBudd 12 views 3 comments 0 points Most recent by NBudd 03/27/20

First post 03/27/20,Last post 03/27/20
Hey all! This is so simple but having issues. I want to show "1" "2" or "3" for "Low" "Medium" "High" =IF([Level of Change]@row, = Low, "1", IF([Level of Change]@row, =…
Formulas and Functions123
NBudd
Sumifs Adding multiple criteriaAnswered Question

Answered bradleyesmith86431 14 views 5 comments 0 points Most recent by Paul Newcome 03/27/20

First post 03/27/20,Last post 03/27/20
Good morning, I am trying to add up total hours of a {Project Type} Column if the project type contains the following: Implementation, Implementation - Small Market, and ELD Implementation =SUMIFS([Hours Worked]:[Hours Worked], Date:Dat…
Formulas and Functions145
bradleyesmith86431
How to count incomplete tasks using % Complete?Accepted Answer

Accepted Answer Thomas Yonker 12 views 4 comments 0 points Most recent by Paul Newcome 03/27/20

First post 03/26/20,Last post 03/27/20
Hi, I've got a project I've imported from MSProject, and my smartsheet has a % complete column. I'm trying to use COUNTIF to identify the number of tasks that are unstarted, those that are complete, and those that are in progress using th…
Formulas and Functions124
Thomas Yonker
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/20

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
SUMIF/SUMIFS based on criteriaAnswered Question

Answered Jessintha Nathan 9 views 3 comments 0 points Most recent by Debbie Sawyer 03/27/20

First post 03/27/20,Last post 03/27/20
Hi! How do I sum a specific category (Primary Column) with reference to a separate sheet. I keep getting multiple errors: https://us.v-cdn.net/6031209/uploads/332/RGPFM8JD7HIF.png
Formulas and Functions93
Jessintha Nathan
End of Month FunctionAccepted Answer

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

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/20

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
Countif a cell is blank or dated before a dateAnswered Question

Answered s_mawer 19 views 9 comments 0 points Most recent by Debbie Sawyer 03/27/20

First post 03/26/20,Last post 03/27/20
Hi all I'm pulling my hair out trying to figure out the correct way of writing a Countif a cell is either blank OR contains a date before a date referenced in a different column. I've been playing around with =COUNTIF({DateClosed},OR(ISBLA…
Formulas and Functions199
s_mawer
OR in SUMIF functionAnswered Question

Answered Sharareh Zand 8 views 2 comments 0 points Most recent by Paul Newcome 03/27/20

First post 03/27/20,Last post 03/27/20
Hello, I am trying to use OR in SUMIF function as below but get invalid operation error: =SUMIFS({Q1 '20- LE}, {Group}, [Primary Column]82, {Project Type}, [Column2]81, {Confidence Level}, [Column11]83) + SUMIFS({Q1 '20- LE}, {Group}, [P…
Formulas and Functions82
Sharareh Zand
Want to auto remember the last time value from other cell

Florence Li 9 views 1 comment 0 points Most recent by Andrée Starå 03/27/20

First post 03/27/20,Last post 03/27/20
I have one case，want to mark the origin value，for example: https://us.v-cdn.net/6031209/uploads/002/28PCFK7G2AA6.png How can I do this?
Formulas and Functions91
Florence Li
Calculating 13 weeks moving averageAnswered Question

Answered Jessintha Nathan 21 views 3 comments 0 points Most recent by Jessintha Nathan 03/27/20

First post 03/21/20,Last post 03/27/20
Hi! How do I calculate 13 weeks average for a series of data in a column? I need the formula to detect every incremental week add of data. Thank you!
Formulas and Functions213
Jessintha Nathan
Accumulative Formula required for daily cadence?Accepted Answer

Accepted Answer chris.italiano78351 18 views 9 comments 0 points Most recent by Andrée Starå 03/26/20

First post 03/25/20,Last post 03/26/20
Good Morning Hope someone can help me. I want to keep track of the accumulative total for each spreadsheet. For example see below - Tomorrow when i enter in Thursdays actual data of 5 - i would like: The bottom total to add up to Target to…
Formulas and Functions189
chris.italiano78351
How do I create a formula to capture the total number of inquiries by group name?Answered Question

Answered Beronica Muller 6 views 1 comment 0 points Most recent by Paul Newcome 03/26/20

First post 03/26/20,Last post 03/26/20
I am trying to create a formula to capture the total number of inquiries by plan group name? I can use the formula =COUNTIFS({National Alliance Operation Inquiries Range 2}, "GROUP NAME", however, I have over 200 groups to choos…
Formulas and Functions61
Beronica Muller

Formulas and Functions

Formulas and Functions

Discussion List