-
Reporting most recent inventory number
I'm creating a dashboard for my clinical leadership so that they can see how much PPE staff is reporting is available onsite. I've created a form that staff will use to report current stock numbers but I am stuck on how to have the most recent reported number be reflected on a widget in a dashboard? Staff will be reporting…
-
IF function question for blanks
=IF([Actual Closure Date]@row < [Target Closure Date]@row, "On-Time", "Late") I have this formula setup where it returns "On-Time" vs "Late". How do I add to the formula to stay blank if one of the column values is blank instead of returning a value. Thank you.
-
Using a form, I am trying to score the responses and add up the scores of the responses.
I am trying to use a form to allow the submitter to make predefined selections and to score their responses bases on predefined numbers within their selection. Below is an example of how I formatted the selections the form has for one of the columns. The numbers in "quotes" are the score for the response. I'm hoping to use…
-
I am trying to count the total of extensions completed more than 30 days from my contracts sheet.
=COUNTIFS(Team:Team, "EPS", Disposition:Disposition, "Extend as is", QTR:QTR, "FY22 Q2"), AND([Days Extended prior to Expiration]:[Days Extended prior to Expiration], >30)
-
Help with Formular with two criteria adding to date value
Hello, I am assisting a team in moving from an excel sheet to Smartsheet. The formula they currently use to perform a calculated function isn't working and I am getting INVALID DATA TYPE as the error. I admit I am not the best formula writer. Basically if the new row meets he two criteria only then should the cell populate…
-
Formula for RYGB Status
Hi, I'm currently using this formula for status health but it's not the best because "Not Started" status is not showing Red if the End Date for the task is in the past. Obviously, the task is overdue even if it hasn't started. Can anyone assist to make this formula better? =IF(Status@row = "Complete", "Blue",…
-
If/Then Logic - Based on What Letter a Name Starts With
I am trying to create the following logic in Smartsheet If Name starts with A through J, THEN Column A = Project Manager A If Name starts with K through N, THEN Column A = Project Manager B. Excel has this =CHOOSE(MATCH(UPPER(LEFT(A2)),{"A","K","O"}),"Project Manager A","Project Manager B","Project Manager C)
-
If/Then formula for symbols based on range?
Hello, I'm collecting responses from multiple departments for the same question. I've added the question to a parent row, and each department is a child row below it. Status is a ball symbol...red=issue, yellow=in progress, and green=complete...and every row has a symbol. I'd like to create a formula on the parent row…
-
Sumifs with AND and OR Criteria
Hi, I'm trying to collect a "Total Amount" if the following criteria is met: The "Category" is "Banking" The "Owner" is "Resident" The "Account Type" is "Checking" or "Savings" I figured out how to do Criteria 1 and 2. It's Criteria 3 that is getting me stuck. I know I can combine a few different Sumifs formulas together,…
-
COUNTIFS using multiple ranges
I am so sorry this is so simple but I am new and eager to learn. I already googled and couldn't find. I have a report that is counting how many tickets are in different countries and their severity. I want to know how many tickets Mexico has in Critical status. So my fields are Country and Severity. I can get a count of…
