-
0 being added to my weekdays
Hi all! I'm trying to list the weekday (using WEEKDAY) based off my date field. It's so weird though, I'm getting a "0" added at the beginning of every day besides Monday and Sunday. Does anyone know how I can fix this? I tried using "&" and "," instead of plus signs, but that didn't work. =IF(WEEKDAY([Calendar Date]2) =…
-
=JOIN formula with two COLLECT statements
Hey Community, I'm running into a roadblock with a formula that I thought was correct, but its coming up with the error #INVALID DATA TYPE. Here is the formula I'm using in reference to the pictured cells attached: =JOIN(AND(COLLECT([TOPIC2]:[TOPIC2], [TITLE2]:[TITLE2], TITLE@row), COLLECT([TOPIC2]:[TOPIC2],…
-
Is there a way to calculate the last business day of the month? Or the 3rd business day?
I would like to run an automation on the last business day of the month, and on the third business day. is there a way to schedule the automation for that or to create a calculated date field that determines the x business day of the current month? Thanks for your help! Sheila
-
Add four months to a Date
Hi, I'm trying to get the first of the month that is four months after a specific date. 1/15/20 should return 5/1/20. The date is in a column called Admit Date and I'm using the following formula: =DATE(YEAR([Admit Date]@row), MONTH([Admit Date]@row + 120), 1) However, when four months later is in 2021(Meaning, the admit…
-
How To Calculate Number Of Days In Month So Far
I am wondering if there is a formula to calculate the number of days in the month to date so I can use it in a formula to calculate a monthly trend. For example, by the 10th of December we have 24 closed deals and we need to calculate the monthly trend to see if we're on track to hitting our targets. With the above…
-
Why is this formula not working?
Why is this formula not working? For the life of me works in excel. =COUNTIFS({Network Security Projects Range 1}, [NetSec Group]2, {Network Security Projects Range 6,"Arlyssa Jaquez"})
-
VLOOKUp Help!
Hi there, I am trying to return a value (site ranking) from sheet 1 to sheet 2 where a value (site #) matches that in my second sheet, but I can't see to get it to work. I have tried: =VLOOKUP([Site #]@row, {FL-101 Feasibility Questionnaire Raw Data Range 3}, 3) Any ideas? Thanks!
-
COUNTSIFS
Hi there, This might be a basic question, and for that I apologise, but I am trying to get the following formula to work... =COUNTIFS({Quotevine Report Range 1}, "User Name", {Quotevine Report Range 2}, =1) Essentially I want to count entries from a sheet as long as a certain User Name is matched and a certain Number which…
-
Formula to create a number assignment catalog part 2
Hello, I have created a number assignment catalog but am hoping there is a formula that can adjust how these numbers are assigned. What I am trying to accomplish is: When the form is filled out for a new product with the Department Name and Category name. that the fixture number will auto fill with a numeric value XXXX the…
-
Removing a Field completely from a Form
I am unable to delete a Heading/Description from the Field Column and it is cluttering up the columns on my sheet. I am able to Delete it from the Form however it just sits in the Field column, When I click remove all my form clears out completely, please help