-
Formula for calculating days from date range
I have two sheets Sheet A (contains only applied leaves, not all the dates range) Column 1 - Leave Start Date, eg 01 jan 24 Column 2 - Leave End date, eg 03 jan 24 Column 3 - Employee code, eg ABC001 Sheet B (contains entire range of dates for particular year) Column 1 - Date range (i.e. 01 jan24 , 02 jan24 , 03 jan24 ,…
-
Formula issue
Hi Brain Trust I am trying to count all the AWFH within a range (Jan24) when the Corporate Row = Dept range in the reference sheet have tried a couple of options but not getting the results i want =COUNTIFS({Jan 24}, "AWFH - ADHOC WORK FROM HOME", {Dept}, Corporate@row)
-
How to write COUNTIFS with a NOT element
I have a working formula for looking up an external reference sheet. All the external fields are tagged with an M: =COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM}, Metric@row) but I now need to exclude a third criterion {ThemeM}, "History" I tried adding it as =COUNTIFS({ReportM}, "Jul 24 - Oct 24", {ProjectM},…
-
Count specific day qty in date range.
I'm trying to write a formula to look at the range of dates (start date column and finish date column), and count how many Mondays, or Tuesdays etc are within that date range. Specifically I have 3 columns to calculate. How many week days (2, 3, 4, 5 or 6) are in the range; how many Saturdays (7) and how many Sundays (1)…
-
Sum(Collect Calculation giving #Circular Reference Error
=SUM(COLLECT({Forecast Amount}, {Customer}, $Label@row, {Sales Stage}, Qualification$1)) That is the calculation I am using bring forecast sales based on Customer and Sales Stage into a metrics collection sheet. I am going out to the Sales Pipeline sheet for the information, two (2) sheet prints attached for reference.…
-
IF formula help resquested !
I'm trying to to create a formula that turns in a number the text in a row. this formlu is working : =IF(FREQUENCE@row = "Probable FREQUENT"; 5) but when I try to add other text it just doesn't work. I would like to create a formula that gives me these numbers in these conditions : Probable FREQUENT = 5 Probable MENSUEL =…
-
Formula to mark the checkbox for the newest date in a row
I have two columns in a form: Current Status and Date of Completion. The Date of Completion column should be updated on a weekly basis. I want the Current Status to check off based on the latest Date of Completion. Is there a formula to do this?
-
Filtering a sheet through a workapp lens.
I have a sheet shared to my workapp. My team is noticing they cannot do a filtered view when referencing this sheet on the workapp. Is there a way we can udpate this? Do I need to reattach this as a report or dynamic view, and if I do that can my team still make live edits to the sheet?
-
Need Help with Auto-Generating Project IDs in CopyRow Automation
Hello Everyone, I'm looking for some advice on automating Project ID generation in our CopyRow Automation process. My department uses this tool for project intake when sending work between teams. However, we need to include a unique Project ID that transfers to the destination sheets. Currently, our project managers spend…
-
Need help with "if" formula
help! I would like my "outside lead time" column to populate a number when different options are chosen in my "outside process" column. Example, if passivate is chosen then i want outside lead time to populate "5", ideally if 2 items are chosen in outside process it would add the 2 values in "outside lead time example…
