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
Formulas and Functions19ginamt3
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 Functions14Damon Lloyd
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 Functions9Peggy
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 Functions16Brian_Anderson_Vegas
What am I doing incorrectly with my formula below? I'm receiving an incorrect argument error.
=IF([Team Number]28 > 0, YEAR(Date3) = "2021", MONTH(Date3), IF([Team Number]28 = 0, YEAR($Date$2) = "2021&qu…
Formulas and Functions30Amy Evans
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 Functions13Matt Foss
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 Functions90SammyMorey
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 Functions22Vickie Lim
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 Functions18Kiera3
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 Functions19Lyn Pringle
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 Functions11Stavros_McGillicuddy
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 Functions23Chanee Batton
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 Functions24dsmartsheetuser
This discussion was created from comments split from: Working with Symbol Formulas.
Formulas and Functions23System
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 Functions22Allan Kelsch
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 Functions18Rivky Emert
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 Functions18Prajna Jain
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 Functions12Ron Anderson
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 Functions32Marilen.Navarro103391
=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 Functions14Dawn Skirvin
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 Functions28Shesha_K
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 Functions13Brian Becnel
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 Functions22FreezeBrew
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 Functions15Tanya Brooks
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 Functions12Jennifer Seymour
Is there a way to take a column:
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 Functions12Jennifer Seymour
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 Functions16Elaine Bye
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 Functions25Rebecca Panaccione
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 Functions17Alessandro Terranova
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 Functions15Doyle54