-
IF(And formulas to count late dates
I would like to create a formula that measures the health of a project (Red, yellow, green) with missing dates: Expected Date (June 6, 2019)- I assign that date to the vendor Scheduled Date (this is expected within 5 days of assigned expected date)- this is filled in by vendor Completed Date (this is expected within 5 days…
-
Formula for cells with multiple assignees
Hello, I have a projects list that allows multiple people to be assigned. What is a formula I can use that will count someone's name when a cell has their name plus other(s)? Thank you in advance. Formula will be used as a basis for a dashboard
-
Using COUNTIFs with FIND & AND
Hi, I need to add up the following: 1) All Labeled as Country X from a Qualitative field that is requiring me to use the FIND function. 2) All labeled as AreaY across 3 columns (I have tried selecting all columns as a range and also just selecting the relevant rows as well). Currently using: =COUNTIFS({Consultant…
-
Report Viewability
So I have created several Reports and have noticed that when you add them to a Dashboard, anyone with Dashboard Access can view them as a Widget; however, When made a viewer on the Report itself, all the people see is a blank page. Do the Viewers also need access to the sheet the report is pulled from? If so then reports…
-
If, Then Formula
Hi everyone, I've searched through the community but couldn't find the right solution. I need to feed specific sales metrics into a dashboard but want it to update, according to the Today column. I receive the previous months information on the 15th of each month, so the formula would need to cover a 45 day period. I added…
-
Moving Average
Greetings Is it possible to plot simple moving average on Smartsheet ? Thank you
-
Sorting install dates in ascending order without the parent function interferring
I divided all of the PM's into parent functions and then have their jobs listed as children functions currently. One of the applications they want is to be able to filter by installer then sort the install dates by ascending order to see if there are any overlaps. However; when I enter the filter and then sort the dates it…
-
How to write Nested IF statements each on separate line?
Hi, I have this nested IF statement that I would like to have each IF condition on a new line for easier reading and to follow coding best practices. Here is what I have now: =IF(COUNT(CHILDREN([Task Name]@row)) > 0, IF(COUNTIF(CHILDREN(), "Red") > 0, "Red", IF(COUNTIF(CHILDREN(), "Yellow") > 0, "Yellow",…
-
IF AND OR
Hello all, I'm looking to use a Created By column to auto-fill my Primary column with a specific user's first and last name. I was planning on listing each user's email and full name with some variation of a IF/AND/OR or IFERROR statement, unless there's a more efficient alternative. Here is my current and one of many…
-
Auto-populating dates
I have several categories in my 'Status' column. (Sprint Backlog, Planning, In Progress, In Review, Changes, Print Files Ready, Print Req Sent, With Printing Services, Complete, Blocked) I would like to have a date automatically populate when the Status becomes 'In Review'. Then, once that date is populated, and if the…