-
Countifs and NOT(ISBLANK)
Hi, I'm hoping someone can point me in the correct direction. I'm trying to get a Count of the amount of unit of a specified category if they are not yet assigned. Basically, I have Column "STOCK" that I want to count what is assigned in box SEARCH201 if "ASSIGNED" is empty. This is what I have so far:…
-
Cant figure out Summing 2 columns based on text in another
I'm trying to sum up two budget columns, based on the budget type in another column. For some reason I keep getting errors and can not figure this out. =SUMIF(Program:Program, "BDM", [PO Raised]:[Planned, not POd]) Program Column = Text/Number = "BDM" PO Raised & Planned, not POd columns are also text/number columns that…
-
Can you use the IF functions on drop down lists?
I am wondering if anyone has used multiple dropdown list columns that are essentially parent, child, ancestor so if parent column choice is ... then child column choices are .. and if ... ancestor choices are Thanks. MoFo
-
Entry date/Payments
I have a sheet that tracks payments made by certain clients. When I add a new client that payment is due in June, the formulas are putting in automatically, payments that "should" have been paid in May. How do I make it so that the sheet won't calculate until the "entry date"?
-
How to make my due date column continuous and with a specific time range in between dates
I am trying to make the due date column so that it enters a date for every 22 days. I want this to be an "endless" column in that it goes all the way down without having to be manually entered. Is there a way to set the due date column to calculate this automatically and fill out all of the rows under it?
-
Nested IF AND with Multiple logics - Not bringing the expected outcome
I am trying to write the following logic to calculate the SLA breach. LOW - Greater than - 7 days MEDIUM - Greater than - 4 days HIGH - Greater than - 2 days CRITICAL - Greater than - 1 day. However, the formula is not accurately bringing the breach/no breach as expected. Except "Critical" all of the other severity logics…
-
Recurring Tasks
Hello I am setting up a smartsheet that will be used to track all the recurring task we have to do in a year. The frequency at which these repeat vary drastically so I wanted to see how one would format their sheet to account for this. For example I have a task that needs to be done the Monday following all major holidays…
-
Auto number risk column only adding till row 20 to another sheet reference
Dear reader, I came across a unique issue and need a help. I created a 'portfolio sheet' with list of projects in one column and a next column for Risk ID with text single line I created a separate sheet 'Risk register' with a dropdown of all the projects similar to the portfolio list and added a Risk ID column with #Auto…
-
HELP What am I doing wrong in this formula?
=INDEX(COLLECT({Unit/Manager List WI Range 1}, {Unit/Manager List WI Range 7}, [Area of Study Parent]@row, {Unit/Manager List WI Range 8}, [Area of Study - Nursing]@row, {Unit/Manager List WI Range 9}, [Area of Study - Radiography]@row, {Unit/Manager List WI Range 10}, [Area of Study - Rehab Services - PT/OT/ST]@row,…
-
Formula Question for IF(AND(NOT(ISBLANK(
I have a sheet that contains book information and want to index/match date from another Smartsheet as long as the date in the column called Most Recent Available Date@row is greater than today AND InventoryID@row is not blank. If either of these is not the case, then I just want an empty cell. Here is the formula I…
