-
Formula to Return Value Based on Multiple Criteria "If-And"
I'm trying to write a formula to return a value based on multiple criteria. I've gotten other similar to work, but this one is not returning the correct value for some reason (or not clearing the value to a blank ("") when it should). The value I'm trying to have the formula return is "Open Go-Back - Corrections Submitted"…
-
Array and Index Training Records to pull who needs to complete something within a date range
I manage training records and am creating a dashboard to manage who needs to complete a training. I have a master sheet with the employee name, and a reference column to them completing the training and when it is due I then have a calculation sheet to count how many people fall within that date range =COUNTIFS({HiPot…
-
Invalid Data Type - trying to return 1 value for multiple field scenarios
Here's the formula that is currently returning the Invalid Data Type error...haven't had much experience writing more advanced or nested formulas so welcome any help! =IF(AND([Build Approved]@row = 1, "Build Approved", "Design"), IF(AND([Install Complete]@row = 1, "Installed", "Build Approved")), IF(AND([In Production]@row…
-
Simple Sum question
This is a simple one but just having a hard time getting it to work. I have multiple clients who purchase a variety of products per invoice. I need a Sum of the Product Type per Client. I've attached an image. For example, I'd like to know Sum of Product 1 for Client 1. In this case the running total =5. I realize I could…
-
table to a list
Hello, I have a budget sheet that records different expense down the side along with additional data (for example, Expense A, vendor, Department, activity -each in a different column). Across the top of the table are months (Jan, Feb etc). The expense for an activity is recorded in the month it is forecasts to occur. The…
-
Trying to add the Supervisor column, Manager column and Master column to all populate
Trying to add the Supervisor column, Manager column and Master column to all populate in the "Leaders" column all as contacts so that all leaders have 1 dashboard connected.
-
Metrics NOT updating periodically as expected
Not sure if anyone is experiencing this. I've created a METRICS sheet for every project that sums up counts for Task Health in order to present on Dashboard through Graphs. I'm noticing that theses metrics are NOT automatically updated unless I refresh the page a dozen times OR re-write the exact same formula again. But…
-
"Invalid Data Type" Error - Need Formula Help!
I am trying to add 3 years from the "Date Completed" column; however, I'm getting the "INVALID DATA TYPE" for the cells where "Date Completed" are blank. I'd like for the "Date of Renewal" to stay blank if the Date Completed is blank. =DATE(YEAR([Date Completed]@row) + 3, MONTH([Date Completed]@row), DAY([Date…
-
After 3 occurrences, an action is taken? Is this possible?
I am wanting that after someone has entered information on someone 3 times it triggers an email to be sent or action to be taken. Is SmartSheet able to do this?
-
SUMIFS and CONTAINS or MAX
Here's a fun one that's got me scratching my head. So I am trying to add the rows that contain the terms Agile Kanban and waterfall. SUM works, =SUMIF((Variable$2:Variable$9), HAS((Variable$2:Variable$9), (Variable@row)), (A$2:A$9)) returns a 0 and =SUMIF(Variable$2:Variable$9, CONTAINS(Variable@row,…