-
Sheet with Single Row needs formula across the row?
I have a sheet of indicators that pulls info from another sheet to process the correct indicator. I now need to set an overall status in the same row from the other indicators Here is the sheet and it will always look like this just one row So the second column Program needs to have a formula that looks at all the other…
-
Pull latest date of a task from a Task Sheet to a Latest Contacted Sheet
Hi community! I'm trying to find a way to have two sheets linked together. 1st Sheet: "Task Dump" where I can input the day-to-day tasks & notes after chatting with customers. Columns: Customer Name | Date | Type of Task | Action Items | Addtl. Notes 2nd Sheet: Pulls in the latest contacted date, type of task, action…
-
Index Match formula work around for Dynamic View
Hello, I am trying to find a solution for a sheet that has multiple lines with the same store#'s and inventory on multiple rows. This is not a shared sheet to our group, so I want to be able to index match this information to another sheet so we can use the info for internal purposes. I dont have the knowledge of how to…
-
Comparing Dates
Hi, I have a Planned Date and Actual Date and Final Date column. I need formula where Final Date column, has Actual Date, but when Actual Date is blank Final Date should have Planned Date. Planned Date | Actual Date | Any help is much appreciated! Thank you!
-
Total Payment monthly breakdown based on Start and End Date Columns
Hi Everyone, I need some support with a formula, if anyone can help me 😁 I have the below sheet where I have created costing for resource use between a Start and End Date Column supported by a total day column count between the two dates and use a day rate column to multiply the total column. What I would like now to do,…
-
Formula to count how many interviews are within the last 7 days and are this week?
I am try to find the right formula to count how many interviews are within the last 7 days but also count anything happening in the next 7 days. The formula I used for the last 7 days is: =COUNTIFS([Interview Date]:[Interview Date], @cell <= TODAY(), [Interview Date]:[Interview Date], @cell > TODAY(-7))
-
Array formulas for project completion in Smartsheet
Hello, I have a project plan in Smartsheet with 2 columns: % Complete Relative weight of completion This cells are used in parent rows (the phases of the project) and are used to indicate the completion of a phase but also the relative amount of effort that each phase has (as an average is not accurate enough) I would like…
-
result with index/match but not index/collect
Hi, I have a formula with multiple conditions, so I used index/collect to pull the data. However, that didn't pull the data. Basically, if the ID# in sheet A matches sheet B and the details column in sheet A is not blank, it should pull the details in sheet A. =IFERROR(INDEX(COLLECT({details}, {ID#}, [ID#]@row, {details},…
-
How to check if children cells are blank?
When the following formula is applied =IF(COUNTIF(CHILDREN(), OR(@cell = "Yes", @cell = "N/A")) = COUNT(CHILDREN()), "Yes", "No") it results false positive values since blank children cells are counted. There is ISBLANK() function. How to use it to apply the above formula only if all children cells are not blank?
-
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…
