-
I'm trying to count the number of instances of a keyword in one cell (for instance if I have "Green Apples; Yellow Bananas; Brown Bananas; Reg Apples" in my Products column for this row, I want to count the number of times "…
Formulas and Functions40
Shannon Petersen
-
I created a work flow to copy a row to another sheet. At first i use criteria when the reference number changes to any value, copy to another sheet. that worked. But when i added additional criteria of "AND when the Date of Final Appr…
Formulas and Functions24
Susan Grunenwald
-
Hi I am trying to do a count if to see the following
if the value selected is Milestone
and the status selected is Complete
at the moment I have tried this =COUNTIFS(Value:Value, "Milestone", Status:Status, "Complete"…
Formulas and Functions13
Ruth Potts
-
Hello,
I need to create a report showing weekly "BOOKED" per category and associate. Weekly is from M-F.
(Image)
My sheet looks like this below:
(Image)
Thank you so much.
Formulas and Functions24
Marilen.Navarro103391
-
Having a blank mental moment. I am trying to create a sum if formula to total all of the "medium" priorities using a range of numbers. High is fine as i just did a greater or equal to (>=) and likewise (<=) for the low. Whe…
Formulas and Functions15
Natasha D
-
Hello,
I'm trying to figure out the right formula to change the RYG status ball depending on the status set in two different cells. I've tried various IF and OR combinations referenced in community threads but am missing something.
Here's …
Formulas and Functions17
Josh Lowry
-
Hi,
I'm looking to track information that has been received late on some sheets. See below example where date information required was 17th July and we received the info on the 26th July.
I am using =IF([Date Information Received]@row >…
Formulas and Functions8
John Kelly
-
I want my column for progress (Not started - In progress - Complete) to update when someone adds the % complete. So is "0" then read "Not Started", If < the 0 but not 100% then "In Progress" and if 100% the…
Formulas and Functions23
Terry Bonet
-
In an effort to scale up a department Smartsheet Dashboard I developed using Summary Sheet Reports for my organization, I am faced with trying to include data from a category where the category information is unknown. Meaning the category …
Formulas and Functions12
John Crabtree
-
See attached image
The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me.
There is a formula for Target % complete:
=IFERROR(…
Formulas and Functions34
LLaCosta
-
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 Functions185
majdesber
-
Hi all,
We have several task schedules that people use to track the status of their work. When the task is finished, they change the Status to Complete and the Percent Complete to 100%. We would also like to know the actual date the work…
Formulas and Functions18
Susan B Peck
-
Hello
I have over 100 smartsheets with the exact same columns and questions. These sheets have been sent out to leadership teams across the country. I need to combine all this data into ONE summary sheet.
Is there a way to do that? I do n…
Formulas and Functions12
Tammy Parker
-
Hi, I have a sheet with active jobs, some are scheduled and some are not. I want the Sheet Summary field to show the furthest date listed, but some of the rows do not have a date in the selected date column, and I want to be able to select…
Formulas and Functions11
Kacie Dean
-
I am trying to think my way through this and can't quite manage it yet.
I have a log that has stages but the criteria is based upon the substrate chosen.
(Image) If Hot dip is selected, the temperature spec is 120-160.
If Cold Rolled St…
Formulas and Functions91
beth_linder28141
-
I'm having trouble with the multi select dropdown option. I have a sheet with the data/responses. I'm creating another reference sheet trying to count the responses. So example, here's my test data. There are multiple options for fruit.
(I…
Formulas and Functions17
JulieH
-
I have a need to count rows where:
Issue Type = Story
Labels include LND-Product
Status = Done
Year of Resolution Date = 2020
COUNTIFS({JIRA Tickets Issue Type}, "Story", {JIRA Tickets Labels}, "LND-Product", {JIRA Tic…
Formulas and Functions29
Pamb10
-
(Image) Hi,
I am trying to track progress through various stages of publication (the columns titled approval, data collection, analysis...accepted). I thought the health bubbles may be a good way to quickly visualize progress but it is c…
Formulas and Functions20
Esperanza Zagal
-
Good morning,
I have specific coding for each line item that reads as 7 digits with a "." followed by another 7 digits. So in essence, it looks like a long decimal. Smartsheets thinks it's a decimal and rounds it up, eliminating…
Formulas and Functions12
Dominick Vargas
-
I am attempting to take info from a column from two different sheets and combine the total.
The formula I am working with to perform this for a single column is:
=COUNTIF({Project Plan - Project A Range 1},="Complete")
I tried us…
Formulas and Functions11
Lori O'Daniel
-
Where [Begin]@row = DATE(2020, 7, 1) and [End]@row = DATE(2020, 7, 31)
The following formula returns returns incorrect value:
=SUMIFS({Maint-MLR-LaborHours}, {Maint-MLR-DateCompleted}, AND(@cell >= [Begin]@row, @cell <= [End]@row))
B…
Formulas and Functions14
Wes
-
Hello,
Basically, I am trying to write a formula in the Sheet Summary of a sheet that shows the contents of another cell on a different sheet. I am able to write a within sheet cell reference for example, =[Latest Update]77.
However, I wa…
Formulas and Functions16
Rashaun Geter
-
Hi,
I have a form that once completed populates a sheet. The form has about 100 items. The idea is that 100 items represent 5 categories. For each individual that completes the form I need to provide an average from the 100 responses that …
Formulas and Functions31
Matt K
-
Hi
when i run a summary sheet, if the sheet uses drop down cells it does not pickup all the items I want to count.
for example if i have Internet Access and TV Systems in same cell it does not count the Internet access when i try to do a…
Formulas and Functions14
Paul Molloy
-
Hi all,
I'm searching for a solution on following idea:
I have a sheet with following four columns:
Created (date) | Category (Dropdown) | Previous Status (RYG balls) | Current Status (RYG balls)
Now I want to auto-populate "Previous …
Formulas and Functions14
Heiko E.
-
Hi there,
I am new to SmartSheets and am struggling to use the CONTAINS formula. I need to allow for the option for [Trial Type] to be either Sales Strip, Sales Demo, or both Sales Strip and Sales Demo
The formula below doesn't work if bo…
Formulas and Functions19
Patrick Miller
-
(Image) How can I get the Completion Rate to only show 100% rather than 150%?
Formulas and Functions24
Ashley Pierce
-
Morning Smartsheeters..
Was hoping someone could shed some light on why this statement isn't working..
=IF(Part75 = "Labour", [Supply Price]75 * [Quantity]75)
I'm trying to multiply two cells based on whether the labour cost is…
Formulas and Functions6
John_CGS
-
Hey - I exported my smartsheet to excel (to add a large number of rows) and then uploaded it. I know that column properties reverted to text/number.. and I've changed them back as needed.. except.. the Predecessor column.. can't get that …
Formulas and Functions14
bbelman
-
I am index/ matching from another sheet and it says no match, but there is clearly a match!
I have moved the information into the same sheet to see if it would pick it up and it does but only some rows. I don't get it!
Formulas and Functions38
SJO
