Formulas and Functions

Counting Parent Row for WeeksQuestion

Answered - Pending Review ginamt3 19 views 3 comments 0 points Most recent by Paul Newcome 07/02/20

First post 07/01/20,Last post 07/02/20
I want to be able to Count the yellow parent weeks to say how many weeks out from current week is. For example week of 6/28 is current week. I want the proceeding weeks to say for example 7/12/20 - 3 weeks out 7/19/20 4 weeks out The curr…
Formulas and Functions193
ginamt3
IF(AND's and IF(OR'sAccepted Answer

Accepted Answer Damon Lloyd 14 views 3 comments 0 points Most recent by Paul Newcome 07/02/20

First post 07/01/20,Last post 07/02/20
I have the below formula working to assign a price pursuant to particular job's complexity. =IF(COMPLEXITY517 = "LOW", 1000, IF(COMPLEXITY517 = "MID", 1500, IF(COMPLEXITY517 = "HIGH", 2000, IF(COMPLEXITY517 = …
Formulas and Functions143
Damon Lloyd
Help with iferror

Peggy 9 views 1 comment 0 points Most recent by Genevieve P 07/02/20

First post 06/30/20,Last post 07/02/20
Hi, I have this formula that i have written. It works fine, but I am getting blank fields, when I was expecting N/A. The product line row has EBS, JDE, SAP. The TLR Scope is Financials, HR, Payroll For EBS I want values returned and N/A f…
Formulas and Functions91
Peggy
Graphing DataAccepted Answer

Accepted Answer Brian_Anderson_Vegas 16 views 3 comments 0 points Most recent by Genevieve P 07/02/20

First post 06/26/20,Last post 07/02/20
PROBLEM 1 Is there a way, then graphing data from a sheet to have it automatically pull in the data into a graph when new rows are added? Currently, I click the graph widget on the Dashboard, and select the data I want to graph - but when…
Formulas and Functions163
Brian_Anderson_Vegas
NESTED IF STATEMENTAccepted Answer

Accepted Answer Amy Evans 30 views 3 comments 0 points Most recent by Genevieve P 07/02/20

First post 06/26/20,Last post 07/02/20
Hello, What am I doing incorrectly with my formula below? I'm receiving an incorrect argument error. (Image) =IF([Team Number]28 > 0, YEAR(Date3) = "2021", MONTH(Date3), IF([Team Number]28 = 0, YEAR($Date$2) = "2021&qu…
Formulas and Functions303
Amy Evans
Calculating the average of a column based on specific criteria in another group of cellsAccepted Answer

Accepted Answer Matt Foss 13 views 3 comments 0 points Most recent by Genevieve P 07/02/20

First post 07/01/20,Last post 07/02/20
Hello everyone, I am trying to calculate the average of a column based on criteria found in another. The catch is that I don't want to specify the specific text of the other criteria as it is going to be based off of an ever expanding drop…
Formulas and Functions133
Matt Foss
Automated Printing of a Dashboard - or workaround to take a snapshot before month carries overQuestion

Answered - Pending Review SammyMorey 90 views 5 comments 0 points Most recent by SammyMorey 07/02/20

First post 12/23/19,Last post 07/02/20
Hey all, Hoping someone may be able to assist... We have dashboards that show the current live data and that automatically tick over as the months do and all the data changes. It is working fabulously, except we want to be able to take…
Formulas and Functions905
SammyMorey
Sheet Summary - countifQuestion

Answered - Pending Review Vickie Lim 22 views 4 comments 0 points Most recent by Vickie Lim 07/01/20

First post 06/29/20,Last post 07/01/20
Hi there - What is the best way to do a 'count' on a drop down field located at the "summary sheet"? For example: I have a drop down field on summary sheet called "Alignment". It has drop down values such as cost re…
Formulas and Functions224
Vickie Lim
Countifs and past due formula helpQuestion

Answered - Pending Review Kiera3 18 views 2 comments 0 points Most recent by Chris Rea 07/01/20

First post 07/01/20,Last post 07/01/20
I am trying to count the items that have a particular workstream, multiple status (blank, In progress) and Due date in the past. here is my formula: =COUNTIFS([Workstream]:[Workstream], @row "QBR", [Status]:[Status], @row "…
Formulas and Functions182
Kiera3
Forms and Blank RowsQuestion

Answered - Pending Review Lyn Pringle 19 views 2 comments 0 points Most recent by Debbie Sawyer 07/01/20

First post 06/30/20,Last post 07/01/20
Hi, We using a Smartsheet form to capture Covid19 Screening Questions. Once submitted the person has their temperature recorded which is manually captured against the record. The problem I am experiencing is that the person capturing the …
Formulas and Functions192
Lyn Pringle
Create a sub task from a taskQuestion

Answered - Pending Review Stavros_McGillicuddy 11 views 1 comment 0 points Most recent by Debbie Sawyer 07/01/20

First post 07/01/20,Last post 07/01/20
I need to start using sub tasks. I already have hierarchies built into my input sheet. Much of the information on the parent must also be included in the child tasks Is it possible to systemically copy data from a parent task into a sub ta…
Formulas and Functions111
Stavros_McGillicuddy
Where Can you find Smartsheet consultants?Question

Answered - Pending Review Chanee Batton 23 views 3 comments 0 points Most recent by Andrée Starå 07/01/20

First post 06/29/20,Last post 07/01/20
I'd love to find Smartsheet consultants that could revamp, update how we currently use it to maximize, utilize the portal function, address automation's, alerts, set up some reporting etc. Not looking for instructions, but teams that imple…
Formulas and Functions233
Chanee Batton
Auto-populate a value in the cell of a column, based on previous valuesQuestion

Answered - Pending Review dsmartsheetuser 24 views 3 comments 0 points Most recent by Genevieve P 07/01/20

First post 06/26/20,Last post 07/01/20
Hi, Appreciate your help! I have a sheet, where Auto-number is taken up for the first column. I have a Priority Column, which I want to auto-populate based on if the number already exists. Item # | Item Requested | Priority 21 | Test 1 | 1…
Formulas and Functions243
dsmartsheetuser
RYG Column based on % Complete and DateQuestion

Answered - Pending Review System 23 views 2 comments 0 points Most recent by Genevieve P 07/01/20

First post 06/28/20,Last post 07/01/20
This discussion was created from comments split from: Working with Symbol Formulas.
Formulas and Functions232
System
How can I use a formula to track total minutes/hours between Start and End time ?Question

Answered - Pending Review Allan Kelsch 22 views 1 comment 0 points Most recent by Paul Newcome 07/01/20

First post 06/30/20,Last post 07/01/20
Hello, I am looking to see if there is a way to set up a formula that reads the difference of two columns (start time and end time) and converts to "total hours and minutes". What I am trying to do, is set up a sheet where we ca…
Formulas and Functions221
Allan Kelsch
Move Row to Another Sheet Once Everything is Filled InQuestion

Answered - Pending Review Rivky Emert 18 views 2 comments 0 points Most recent by Paul Newcome 07/01/20

First post 07/01/20,Last post 07/01/20
Hi Community, I am trying to make a work flow that moves a row when the Latest Claim Status is Denied. However, I only want the row to move once all the columns are filled in for that row. I don't want any specific cell to be the trigger a…
Formulas and Functions182
Rivky Emert
A working formula to calculate End Date and Time based on Start Date and Time and allocated hours.Question

Answered - Pending Review Prajna Jain 18 views 1 comment 0 points Most recent by Paul Newcome 07/01/20

First post 06/27/20,Last post 07/01/20
Can any one help on getting a formula to calculate End Date and Time based on Start Date and Time and Allocated hours for a Project considering 8 am to 8 pm working hours and excluding Saturday, Sunday and Holidays?
Formulas and Functions181
Prajna Jain
How do I write formula to capture date field changed to approvedQuestion

Answered - Pending Review Ron Anderson 12 views 1 comment 0 points Most recent by Andrée Starå 07/01/20

First post 07/01/20,Last post 07/01/20
I am trying to populate a date column with the date that another column is approved. I am befuddled. My formula returns today's date but it changes every day. =IF([BIC Approved]@row = "approved", TODAY())
Formulas and Functions121
Ron Anderson
SHEET SUMMARY FORMULAQuestion

Answered - Pending Review Marilen.Navarro103391 32 views 1 comment 0 points Most recent by Genevieve P 07/01/20

First post 06/27/20,Last post 07/01/20
Hello, I need to build a sheet summary (report) for all the sum of the table below. I want to show on my Dashboard a Summary of each Status (In Progress etc....for each month... for Jose and Karlo and 5 more not included in my screen captu…
Formulas and Functions321
Marilen.Navarro103391
Need help with RYG status formulaAccepted Answer

Accepted Answer Dawn Skirvin 14 views 3 comments 0 points Most recent by Genevieve P 07/01/20

First post 06/29/20,Last post 07/01/20
=IF([% Complete]@ROW<.7, "RED"), IF ([% Complete]@ROW< 1>.7, "YELLOW"), IF([% Complete]@ROW)=1, "GREEN"),""))) If below/above certain percentages, attempting to change the ball to red/yello…
Formulas and Functions143
Dawn Skirvin
Index, Match, Collect?Question

Answered - Pending Review Shesha_K 28 views 1 comment 0 points Most recent by Genevieve P 07/01/20

First post 06/26/20,Last post 07/01/20
Hello Community, I am hoping someone has a suggestion for my issue. I searched the previously asked questions and couldn't seem to find it. Ultimately, I am trying to maintain one master sheet of data that populates secondary filtered shee…
Formulas and Functions281
Shesha_K
To SUMIF or SUMIFS - Neither are workingAccepted Answer

Accepted Answer Brian Becnel 13 views 2 comments 0 points Most recent by Brian Becnel 07/01/20

First post 07/01/20,Last post 07/01/20
I am a newbie and I'm stumped. I am trying to calculate the remaining budget for projects that have a ProjPortStat(us) as "active" in a field on the Sheet Summary (I can successfully calculate a single column where the status is …
Formulas and Functions132
Brian Becnel
How to take Not Applicable and Completed item in consideration when calculating schedules?Question

Answered - Pending Review FreezeBrew 22 views 2 comments 0 points Most recent by Genevieve P 07/01/20

First post 06/26/20,Last post 07/01/20
Hi, I am working on building construction scheduling. In the template of my schedule, I have a list of items with predecessors. My questions, once I marked one item as N/A or DONE(two separate check boxes), how can I make the following ite…
Formulas and Functions222
FreezeBrew
Ad hoc reportingAccepted Answer

Accepted Answer Tanya Brooks 15 views 3 comments 0 points Most recent by Tanya Brooks 07/01/20

First post 06/29/20,Last post 07/01/20
In forms or reports is ther a way for user to enter a variable? Situation: Sheet contains thouseands of employee names and corresponding information. Do not want users directly in sheet so they need to update information via report. Is …
Formulas and Functions153
Tanya Brooks
last, first to first lastQuestion

Answered - Pending Review Jennifer Seymour 12 views 1 comment 0 points Most recent by Jason Tarpinian 07/01/20

First post 07/01/20,Last post 07/01/20
I want to flip a column which will be last, first names and return first last. So Doe, John becomes John Doe I can get each piece - but is there any functionality to build the string? Having a first name column and a last name column is no…
Formulas and Functions121
Jennifer Seymour
last, first to [email protected]Question

Answered - Pending Review Jennifer Seymour 12 views 1 comment 0 points Most recent by Jason Tarpinian 07/01/20

First post 07/01/20,Last post 07/01/20
Is there a way to take a column: Last, First and build [email protected] Scenario: I have data that is emailed to me as a cut and paste of part of a table. I send an email using the names included in this data. I have no co…
Formulas and Functions121
Jennifer Seymour
I have a report pulling data from multiple sheets on a dashboard: Filter Report?Question

Answered - Pending Review Elaine Bye 16 views 1 comment 0 points Most recent by Genevieve P 07/01/20

First post 06/30/20,Last post 07/01/20
I have a report pulling data from multiple sheets. I have the report on a dashboard. I would like to be able to filter the report from the dashboard? Is this possible?
Formulas and Functions161
Elaine Bye
Need assistance with collecting and then joiningAccepted Answer

Accepted Answer Rebecca Panaccione 25 views 3 comments 0 points Most recent by Genevieve P 07/01/20

First post 06/25/20,Last post 07/01/20
Hello, I have a test master grid sheet where dates of leave (and different types of leave) are collected through a form. Formula used for collecting dates together is: =IF([End Date]@row <= [Start Date]@row, [Start Date]@row + &qu…
Formulas and Functions253
Rebecca Panaccione
Count dropdown and %Accepted Answer

Accepted Answer Alessandro Terranova 17 views 3 comments 0 points Most recent by Paul Newcome 07/01/20

First post 06/30/20,Last post 07/01/20
Hi Community, I am defining the following formula to count how many children cells are blank out of the total number of children cells along with the associated percentage value. In a Team schedule sheet this will count how many time slot…
Formulas and Functions173
Alessandro Terranova
How far can Conditional Logic go to screen? Screen does not workQuestion

Answered - Pending Review Doyle54 15 views 9 comments 0 points Most recent by Paul Newcome 07/01/20

First post 06/29/20,Last post 07/01/20
I am trying to use: CONTAINS(OnePt, @cell), [OnePt]:[OnePt] Essentially I am trying to use Location - OnePt - to see if there is a record of OnePt input into a record. If I cannot use the logic, can you explain the scenario and cell in a c…
Formulas and Functions159
Doyle54

Formulas and Functions

Formulas and Functions

Discussion List