-
Index Collect with Dates
Hi, I'm looking to get a bunch of different outputs based on: 1) an account being the smallest/largest (min(contract spend)) 2) an account being in a given month ({Assigned Date}, IFERROR(MONTH(@cell), 0) = MONTH([Month (just update top row)]@row)) 3) various other variables such as customer segment, etc The thing is, I…
-
tryin to if function with OR and AND
Hi All, If there is a date in 'date found' column and date in 'Date collected' column, Column7=Collected if there is a date in 'date found' column but no date 'Date collected' column, column 7=Uncollected if the 'Date found' column is blank, column7=blank Can anyone please try help @Genevieve P. @Paul Newcome can you…
-
SUMIFS when a column is not blank
I have multiple sheets that I am working from where I need to sumifs a column only if another column in the same row is not blank. This is what I want to do: If {Column C} is Blank or more than 0, Sumifs {Column B}, if {Column A} is checked This is what I've tried: =IF(SUMIFS({Column C}) < 0, "", SUMIFS({Column B}, {Column…
-
How to enter a formula referencing other cells within Duration?
Hello, I have a column where I indicate the budgeted hours available for a task. Within the Duration cells, I would like to enter a formula that takes the budgeted hours, divides them by an efficiency factor and yields the resulting duration available for the task, however, I'm unable to enter any formulas into the…
-
what is the wrong with this
=IF(AND([total]@row = 100, TODAY(0) < [done]@row), "qualified", IF(AND([total]@row < 100, TODAY(0)< [done]@row), "under-qualification", IF(AND([total]@row < 100, TODAY(0) > [done]@row), "not-qualified"))))
-
Resource Forecasting formula
Dear all, I hope someone can help me; I have a large sheet with a row per resource and a set of 4 columns repeating for each week of the year. The first column of the 4 has a week commencing date; this is dynamic based on a start date I enter into a reference cell. The second column in the repeating columns derives the…
-
How to reverse the order in which a range is counted?
Hello, I have the following Smartsheet: In this Smartsheet, I'm building an asset booking system and, for the 'Asset Available During Your Booking Date Range?' column, it displays whether the particular asset is available for the date range inputted by the user. My formula is as follows: =IF(IF([Asset Booking Start…
-
I need to add the number of days in one cell to start date and it needs to be in workdays
I have one column with my start dates and a second column with a varying number of days that need to be added to the start date, and I want the resultant date to be in workdays. I have tried various formulas and have not been able to find one that pulls the value in the second column to add to the start date. Suggestions?
-
Index/Match with Minimum value
Hello Community, What I'm trying to do is use a Helper Sheet to pull two values from other sheets based on a name match. My Helper sheet has a list of names and a few other columns, two of which I'm using to try and pull the earliest date from two other sheets. Those sheets are a Scheduler and PTO Request form. As such, my…
-
How to Create a Query and Update form in Smartsheet
Is there a way to create a form that queries data from a sheet and allows updates to the data