-
If and Question for At Risk Flags
How do I make this work (combine into a single statement)? =IF(ISBLANK([Days Overdue]@row), 0, 1) AND =IF(AND([Days Overdue]@row > -5, [% Complete]@row < 1), 1, 0) New to smartsheets! Thank you.
-
Function takes data in one cell and sent it to another cell?
Hi, Column A has function code in it that finds data I need and put it in a cell. Column B Column C I want to put a function codes in Column B that takes the data from Column A and puts it in Column C. I have a sheet full of function codes and connected to contacts and more I don't want to rewrite. This would be the quick…
-
USING FORMS WITH pARENT /CHILD ASSOCIATIONS IN SPREADSHEET
Greetings, Below is a screenshot of a spreadsheet that has parent / child associations. I would like to create a form that will allow team members to input the various meetings & Times, they have during the week. 1-can smartsheet automatically put the response in child rows when a parent row( week Day) has been selected?…
-
How to use multiple if not or statements
I am receiving an "invalid data type" result when I run this: =IF(NOT(ISBLANK([Start Date]@row)), NETWORKDAYS([Due Date]@row, IF([Date Completed]@row <> "", [Date Completed]@row, TODAY()))) and there is a null value for Due date. How can I add OR statement to this so that if either Start Date OR Due date are (not) blank…
-
Average Guest Check ($) When Some Cells are $0.00
Hello! I'm trying to get the average of a data set IF the cells are greater than $0.00. Unfortunately, the formulas I've tried have all come up as #UNPARSEABLE. I've included an image of the data for reference as well as the formula I tried based on the syntax suggested. Any suggestions? It might also be worth mentioning…
-
Count of a column between two dates
I'm trying to determine how many times we post for a hospital in each year. (Ex: ABC Hospital posted # times in 2022). The formula I'm using now is: COUNTIFS({SS Hospital}, [Primary Column]@row, ({SS Posted}, >=DATE(2022, 1, 1), {SS Posted}, <=DATE(2022, 12, 31))) SS Hospital references the column from a different sheet…
-
Reference Sheet CountIfs Formula
Hi I need help in doing a count ifs in another sheet. My countifs formula currently works in the summary section of the sheet but when doing a sheet reference it doesn't. The working countifs formula is: =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", Status:Status, "Open", Project:Project, "Data Analytics &…
-
Count the number of submissions received each month year over year
I am looking for help creating a formula to count the number of form submissions in each month year over year. Ultimately, I would like to compare if the number of submissions differs in corresponding months year over year. I have Created (Date) column types which I think will help. I've tried using the MONTH() formula and…
-
We have date range column and want to count monthly totals
We have project where we are migrating customers weekly - want to capture the total number of completed migrations by month. I have completed date and a check box when the customer is migrated. How do I do that range for the month?
-
COUNTIFS
I want the formula to count how many risks there are that are open. =COUNTIFS([Risk or Issue?]:[Risk or Issue?], "Risk", ([Status], "Open"))) I can't seem to get it to work. Can anyone help? Thanks