Formulas and Functions

responsibility to more than 1 personAnswered Question

Answered Yashwant Singh 9 views 1 comment 0 points Most recent by Paul Newcome 03/17/20

First post 03/17/20,Last post 03/17/20
Whether it is possible to assign a sign off by responsibility to more than 1 person, and either of persons can provide sign off?
Formulas and Functions91
Yashwant Singh
Help with RYG Balls - Looking for an AverageAccepted Answer

Accepted Answer Laurie Bearden 30 views 5 comments 0 points Most recent by Paul Newcome 03/17/20

First post 03/13/20,Last post 03/17/20
Good morning/afternoon. I have been searching in the help articles and community for an answer to my question, to no avail. I have tried a few different suggestions but nothing has worked so far. Here is my dilemma. I have a sheet that…
Formulas and Functions305
Laurie Bearden
SUMIFS on columnsAnswered Question

Answered Jennifer Levey 13 views 4 comments 0 points Most recent by Paul Newcome 03/17/20

First post 03/16/20,Last post 03/17/20
I'm looking to sum the values in the duration column, if the row is not marked as a bug (this is a checkbox column) and if the district name matches a value (in this case Muskogee). This is what I've come up with and it's not working: =SU…
Formulas and Functions134
Jennifer Levey
I want to count items within current month without needing to change the month manuallyAccepted Answer

Accepted Answer TeeM 36 views 9 comments 0 points Most recent by Paul Newcome 03/17/20

First post 03/12/20,Last post 03/17/20
I need to report on the number of items that appear in the current month to date. Is there a formula that can be applied without necessitating manual entry of changing the month manually?
Formulas and Functions369
TeeM
Moving rows to other sheets with WorkflowAnswered Question

Answered TeeM 21 views 5 comments 0 points Most recent by Paul Newcome 03/17/20

First post 03/16/20,Last post 03/17/20
What is wrong with my Workflow? When the % Complete column changes to 100%, I want the row to move to another selected sheet but it is not happening. https://us.v-cdn.net/6031209/uploads/440/QTEA0M43OEDG.jpg
Formulas and Functions215
TeeM
How to change status based on start/end dates/if completed was checked or not.Answered Question

Answered Caitlin Bowman 15 views 4 comments 0 points Most recent by Andrée Starå 03/17/20

First post 03/16/20,Last post 03/17/20
Hi there, I've been reviewing past topics but haven't been able to get those formulas to work. I have a sheet where there are start/end dates, and a completed check box column. I'm having trouble figuring out how to create a formula where …
Formulas and Functions154
Caitlin Bowman
I want to do a serial IF this then that formula across more than one column. Please help!Answered Question

Answered Sue Crawford (admin) 28 views 6 comments 0 points Most recent by Andrée Starå 03/16/20

First post 02/17/20,Last post 03/16/20
My =IF([email protected]="Name1", "Parent1") and it worked to bring the Parent name into the @row, but I am trying to also add a few other Child/Parent combos into it as well. For example, In the Parent Column, I want to combin…
Formulas and Functions286
Sue Crawford (admin)
Count of Dropdown (multi-select) items in another sheetAnswered Question

Answered Frank Falco 35 views 3 comments 0 points Most recent by Paul Newcome 03/16/20

First post 03/16/20,Last post 03/16/20
I have a sheet that has a column called Steps, Values Step 1, Step 2,...Step 10 From another sheet, I want to count how many Steps happen in a Stage (which contains a number of Steps) I would like a count formula that looks at the Steps in…
Formulas and Functions353
Frank Falco
Need to tweak Health Indicator formula based on "status date"Accepted Answer

Accepted Answer Melissa Kosiewicz 30 views 4 comments 0 points Most recent by Genevieve P 03/16/20

First post 03/12/20,Last post 03/16/20
I need to tweak the following formula to use a [Status Date] instead of "Today". We publish status reports each Wednesday as of Friday of the previous week. I have added a Status Date column that I will update each week to refl…
Formulas and Functions304
Melissa Kosiewicz
Date formula helpAnswered Question

Answered Vyanessa Stephan 25 views 3 comments 0 points Most recent by Genevieve P 03/16/20

First post 03/12/20,Last post 03/16/20
Hello, I'm looking for a formula to pull a date that is 90 days earlier than our start date but on the closest Tuesday. Thank you
Formulas and Functions253
Vyanessa Stephan
Countifs Calculations Multiple Selections in CellAccepted Answer

Accepted Answer Adam Boyle 22 views 3 comments 0 points Most recent by Paul Newcome 03/16/20

First post 03/13/20,Last post 03/16/20
I'm not quite sure how to ask this, but I have cell that has a list of teams you can select from. You can select one team, or have multiple teams selected. If multiple teams are selected then the line item (task) is excluded from the coun…
Formulas and Functions223
Adam Boyle
IF Statement - CheckboxesAccepted Answer

Accepted Answer Mahshad Farmanbar 16 views 4 comments 0 points Most recent by Frank Falco 03/16/20

First post 03/16/20,Last post 03/16/20
Hi there, I currently have this formula (below) for my checkboxes that states if the end date is less than 30 days away and the Status of a project is "In Progress" the checkbox is checked off. Currently, if the End Date field i…
Formulas and Functions164
Mahshad Farmanbar
trouble with formulas applying to new entries from form

steve50951 23 views 10 comments 0 points Most recent by Paul Newcome 03/16/20

First post 02/26/19,Last post 03/16/20
I created a form. new entries are entered at the bottom of the form. I copied all of my formulas to the bottom of the form. When new entries come in from the form, they come in below the last row where formulas are copied. Result...formula…
Formulas and Functions2310
steve50951
Seven Most Current Entries for each Question for Each LocationAnswered Question

Answered Amy Arnold 25 views 4 comments 0 points Most recent by Paul Newcome 03/16/20

First post 03/15/20,Last post 03/16/20
Hi, I want to pull the SEVEN MOST CURRENT ENTRIES for each QUESTION for each LOCATION. Here's my Master Smartsheet. https://us.v-cdn.net/6031209/uploads/745/RJB22XU6CD5F.png This is the formula I started using based on responses in the c…
Formulas and Functions254
Amy Arnold
Matching using Multi-select column valuesAccepted Answer

Accepted Answer Frank Falco 120 views 10 comments 0 points Most recent by Frank Falco 03/16/20

First post 01/14/20,Last post 03/16/20
I have the following three columns Idx, Stage and Steps. Steps is a Dropdown Multi-Select column. I want to use the step value from column in another sheet to find which row that step belongs to so I can return the Idx or Stage values from…
Formulas and Functions12010
Frank Falco
How do I find the average approval time?Answered Question

Answered Shelby Simonsen 17 views 1 comment 0 points Most recent by Andrée Starå 03/15/20

First post 03/13/20,Last post 03/15/20
I have a sheet that our PMs approve invoices and another sheet that copies the rows as soon as they are approved. One column is Date Created (Created Date) and the other is Approved Date (Modified Date). When the row is pulled, it captures…
Formulas and Functions171
Shelby Simonsen
Force upper case on a columnAnswered Question

Answered Juan-JLC 30 views 5 comments 0 points Most recent by Andrée Starå 03/15/20

First post 02/28/20,Last post 03/15/20
Hello Everyone, I got a question. Is there any way to force upper case on a text column? I have a column where users enter information using iPads and it will be very helpful if the cells will automatically force to have upper case font i…
Formulas and Functions305
Juan-JLC
Report? Summery Count of rowsAnswered Question

Answered Xander Brennan 24 views 3 comments 0 points Most recent by Andrée Starå 03/15/20

First post 03/04/20,Last post 03/15/20
I have a sheet that bring in once a week that has our available units and extra data. I need a report to look a this data and return a count of how many units per building are available. Data coming in: Building | Unit Number | Rent Ready …
Formulas and Functions243
Xander Brennan
using the SUMIF formula to pull data from another file and display in a separate smartsheetAnswered Question

Answered Deborah Kardash 31 views 6 comments 0 points Most recent by Andrée Starå 03/15/20

First post 02/11/20,Last post 03/15/20
In Excel I can use the SUMIF formula to calculate data from one spreadsheet and show the sum in another Excel file. Excel Formula =SUMIF('2020 Data'!B:B,A5,' 2020 Data'!F:F) - Column B has Supplier List and Column F has all the amounts …
Formulas and Functions316
Deborah Kardash
Auto Number to Reset Daily (PO #)Answered Question

Answered MCorbin 39 views 8 comments 0 points Most recent by Andrée Starå 03/15/20

First post 03/11/20,Last post 03/15/20
I'm trying to create a PO #. They want to include the date and a sequential number in the PO #, e.g. 2020031100005 2020031100006 I can use the "Auto-Number" function, BUT... they want the number to reset back to 1 for the next …
Formulas and Functions398
MCorbin
Use Conditional formatting to mark cells that contain formulasAnswered Question

Answered RPIArchShop 38 views 6 comments 0 points Most recent by Andrée Starå 03/15/20

First post 02/27/20,Last post 03/15/20
Good Afternoon Smartsheet wizards, While I am relatively new to Smartsheet and have purchased some of the learning, the Conditional Formatting is entertaining. I'd like to prove that certain cells have formulas, or not. Thank you in advan…
Formulas and Functions386
RPIArchShop
Cross reference sheets on email addressesAnswered Question

Answered Dedrick Tai 48 views 4 comments 0 points Most recent by Genevieve P 03/15/20

First post 01/22/20,Last post 03/15/20
Hello, Looking for formula help. I have a master Smartsheet with email addresses and a second Smartsheet with a form that will populate with email addresses entered by the user, so they may not be entered 100% correctly (fuzzy lookup?). I…
Formulas and Functions484
Dedrick Tai
RYG Formatting - Formula for Populating Status using %Complete and Finish DateAccepted Answer

Accepted Answer Lisa Matthews 33 views 3 comments 0 points Most recent by Genevieve P 03/15/20

First post 03/11/20,Last post 03/15/20
HELP!!! I am trying to populate my Status field, using RYG formatting (using the % Complete and Finish Date). The cell displays #UNPARSEABLE. I am not sure what I am doing wrong. I have been reading through the comments in the community an…
Formulas and Functions333
Lisa Matthews
Check a box based on multiple text specificationsAnswered Question

Answered Billy-Rock 29 views 4 comments 0 points Most recent by Andrée Starå 03/14/20

First post 03/12/20,Last post 03/14/20
I am trying to have a box checked if a text matches in a certain column. To do that here is the formula I am using in the "Key Claim?" column which is a checkbox column: =IF([Type of Claim]@row = OR([Key Claim Dealer Codes]1:[Key…
Formulas and Functions294
Billy-Rock
Creating another formula using an existing formula from another cell.Accepted Answer

Accepted Answer Mel Plummer 21 views 5 comments 0 points Most recent by Andrée Starå 03/14/20

First post 03/13/20,Last post 03/14/20
Hi. I am trying to create a formula which uses another formula but keep getting an error message. It works if I use the add (+) symbol but returns an error message when I try to times (*) the cells, i.e. the cost total needs to show the ho…
Formulas and Functions215
Mel Plummer
GroupingAnswered Question

Answered Mike Rini 16 views 5 comments 0 points Most recent by Andrée Starå 03/14/20

First post 03/13/20,Last post 03/14/20
We use SmartSheets to manage our display campaigns. With each of our campaigns, we can have 1 to N different pieces of creative associated with them. I'm looking for a way to group (either by ID, Campaign, etc.) my sheet to show the campa…
Formulas and Functions165
Mike Rini
need help with formulaAnswered Question

Answered tcanelli41471 15 views 3 comments 0 points Most recent by Andrée Starå 03/14/20

First post 03/13/20,Last post 03/14/20
I am trying to create a RYG formula Have a drop down column with the choices: 75% staffing 50% staffing 25% staffing <25% staffing I want to say that IF([Staffing Level Impact to MEF]@row = "75% staffing", "Green"…
Formulas and Functions153
tcanelli41471
GPS location

Etienne Portelance 20 views 2 comments 0 points Most recent by Andrée Starå 03/14/20

First post 03/13/20,Last post 03/14/20
I really like the GPS location that seems to be enabled in the Asset Location template for example. I have about 1000 locations for street furniture we want to upgrade. So we already have the locations in an Excel sheet. How could we trans…
Formulas and Functions202
Etienne Portelance
COUNTIFSAccepted Answer

Accepted Answer MJLaughlin 27 views 3 comments 0 points Most recent by Andrée Starå 03/14/20

First post 03/13/20,Last post 03/14/20
I am trying to create a COUNTIFs for a metric that I need for COVID-19 tracking. I have a datasheet: LOB, and Record Type LOB is a drop down Record type is a drop down either travel or isolation I want to be able to pair up LOB and the # …
Formulas and Functions273
MJLaughlin
Nested IF AND ORAnswered Question

Answered Jturton 23 views 1 comment 0 points Most recent by Sean Morgan 03/14/20

First post 03/12/20,Last post 03/14/20
I am trying to get a formula for a check box that combines an if AND with an If OR. I have a column labeled Rental Billed that is a check box. There is another column that has multiple status options from a drop down. I want the formula…
Formulas and Functions231
Jturton

Formulas and Functions

Formulas and Functions

Discussion List