
I'm kinda new to this. I'm a little familiar with how formulas worked in Microsoft Excel, but not a pro in the slightest. I only know basic stuff.
How do you use a formula to change the value of symbols and check boxes and drop down menus…
Formulas and Functions522
smuhammad41001

I have a sheet that is tracking issues. One column is a category (bug, feature req, UI issue, etc.). The selections are defined in a pull down and isn't free form. I want to create a widget for a dashboard that shows the total number of…
Formulas and Functions5
Rick Segal

I'm working on a project and am hoping for some advice from the community of experts!
I have a sheet that serves as an ongoing list of projects and information about those projects  once a decision is made to either fund the project or d…
Formulas and Functions90
kp801

Hi,
I was wondering if there was a way to get the Report Builder to filter both an include and an exclude in the same column OR get it to filter for an exact word or phrase.
Example: Filter for a column is set to find all entries that …
Formulas and Functions37
LaurenS

trying to add new columns to show some milestones end dates on the parent row.
For example, if i have a summary parent row called "Project 1" and one of the child tasks called "SOW", i want to show the SOW date rolled …
Formulas and Functions527
Ofir Marco

Hi
I am trying to count the number of items that are for a particular month and year.
eg: I would like to count the number of items submitted for the month of Jan 2018
the column I am wanting to pull the data from is a date column
Formulas and Functions15
Kim McNamara

Hi, I am looking for a formula that will allow me to limit the options seen in a drop down based of what is selected from another drop down. For example, Column A would is a State Drop Down and Column B is a City Drop Down but only shows t…
Formulas and Functions25
Kayla Leslie

Both Google sheets and Excel have a shortcut (CTRL+~) that allows you to toggle a view that shows all the formulas in the sheet at once (that is, the cells change from displaying values to displaying the underlying formulas). I find this …
Formulas and Functions237
klsalvini16801

Hi the community!
I am using Smartsheet with French settings, meaning :
* the decimal separator (for numeric values) is ","
* the separator in formulas is ";"
When I use the "@row" reference in a form…
Formulas and Functions49
p_bureau

I'm trying to get a formula that will do the following:
Give me a RYG result in a column, by looking at whether a project item has gotten close to the due date, compared to what the status is on that item.
I want it to give a Red result …
Formulas and Functions13
Digital_Kru

Good afternoon,
Wondering if anybody knows how to enter the following formula that we use in Excel:
=NORMSINV(1(total defects / total opportunities))+1.5
into Smartsheet, we use it to calculate Sigma Levels.
Thanks!
Formulas and Functions101
dsierra

I have users inputting data using a form. The data comes into my sheet at the top. At the bottom of my sheet I have a cell that is summing the numbers in a column called "Sales Amount". Each time a new record is added at the top …
Formulas and Functions98
joe40811

Good Morning.
I am attempting to create a forumula which references another sheet; however, I continue to receive error messages or it doesn't calculate correctly. Below is the outline of what I am looking to accomplish. Let me know if …
Formulas and Functions13
clifka

In process of creating a formula and I can't seem to get it to work correctly. Any feedback is welcome.
I have two columns. Both are drop downs.
Column Program: A, B, C
Column Status: A, B, C, D, E
Would like to create a formula …
Formulas and Functions43
clifka

Hi,
Please can someone help with a formula to find if a row is parent and at the same time has a text that starts with "abcde".
Formulas and Functions39
Meenakshi Sundaram S

I have no idea how the program thinks that the number 2 even approximately resembles the word "Sparks Corp". I want to use fuzzy math to find the closest vendor name to the one that is typed in, and was hoping to use the approxim…
Formulas and Functions56
[email protected]

Hi
I'm using a report to pull together a number of different sheets. I'm looking to do a vlookup on the report. Is this possible? If not can I select multiple sheets in one vlookup?
Thanks
Formulas and Functions213
Joan Bond

Hi Everyone,
I got a great formula from Customer Success that I thought I would share. I wanted a way to know if a project was at least 1 week or more behind schedule. This is what Customer Success gave me:
=COUNTIFS(Finish:Finish, TOD…
Formulas and Functions14
brandon.elmer

I'm needing help completing a formula. The formula that is needed will look specific data in column "A" then specific data in column "B" with the result of these to coming from a different little grid.
I've got the 1st…
Formulas and Functions13
Kelli Lenz

Does anyone have a formula that looks at a line status (Not Started, In Progress, Complete) and then determines whether it is after the due date (red), <7 days (yellow) , or >7 days (green)?
Complete would need to turn green regardl…
Formulas and Functions200
apmarcotte

Hello,
I was wondering if it is possible to write the current SS Sheet name to a cell that you are working on?
The reason that i am checking this functionality is due to how certain project plans are created within a Workspace and i n…
Formulas and Functions138
Anthony

I’m looking for guidance on how I would (or if it’s possible to) automatically generate line items on a decision log from an action item log column value (separate sheets). What I mean is, whenever the value of “move to decision log” is se…
Formulas and Functions211
jcone40331

All,
Have a smartsheet that shows by student (each row is a student) what course they are required to take. The student updates the date they completed the course via update requests. Based on this smartsheet I am trying to find a form…
Formulas and Functions17
Art Miller

I'm having an issue understanding COUNTIFS in my scenario.
I'm trying to track billable hours, and I'd like to summarize the hours value listed if another column equals a specific value. So I can track how many hours go to which projects…
Formulas and Functions14
Amy_API

We do a customer follow up for every job we do. We ask 3 questions rated 110.
If "Overall Score" column totals 2630 points  green ball
2025 points  yellow ball
>20 points red ball.
I can get the column to automatica…
Formulas and Functions13
Mark Dekorte

Hello,
was hoping to get some advice ... i have a long drawn out conditional formatting expression that will turn a row a certain color once it is all met .. at that point i want a box to automatically be checked to indicate that the e…
Formulas and Functions97
dana y

Hello,
We are using Smartsheet as an intake form of new projects. What I need to do is do a COUNT of all the projects that came in for this week and also by product type, and region request. However, the only way I can think of doing t…
Formulas and Functions15
jdawana19896

I have an odd one that hopefully someone can shed light on as i am going a bit crazy :)
I finally figured out a formula i have been working on for few days ...
strangest thing it seems to have been the quotes that i was using ??....
I…
Formulas and Functions14
dana y

So i have two formulas , one works and one does not; hoping someone can see what i am missing here. i have four columns that i need to take into consideration before i automatically check a checkbox . using two of the conditions works; …
Formulas and Functions848
dana y

Hi all,
I'm fairly new to Smarthsheet and have run into a simple COUNTIF formula error. I want to simply sum all cells in a column that contain the text "*C000*". My formula is below and I don't show an error in the formula but…
Formulas and Functions27
PabloG