-
If/Then formula
Column = 2023 Calendar Savings Column = Confidence, which could be 25, 50, 75 or 100 If Confidence = 25 then multiply 2023 calendar savings by .25 then if Confidence = 50 then multiply 2023 calendar savings by .50 etc
-
Countifs with multiple criteria and a "combo" criteria
Hi! I am trying to figure out what I am doing wrong with the below...the formula works until I add the last part "=date(2023,3,14+{Sprint Push}, 1" =COUNTIFS({Target Complete}, =DATE(2023, 3, 28), {Parent/Header Column}, 0, {Early/Late Complete}, "", {Target Complete}, =DATE(2023, 3, 14) + {Sprint Push}, 1) I want to count…
-
How can I write a countif formula formula for a cell that contains multiple entries?
I have been struggling to get a countifs formula to match what I've created on a report so that I can display it on a dashboard. I want to count the number of times our team has had a call on specific topic with our clients. In some cases the conversation covers multiple topics and we log what was covered on the call over…
-
Formula not Pulling Time Stamp Time post 7:00PM Central Standard, Why?
I have a [Time] Column with a formula that uses SUBSTITUTE() and DATEONLY() to pull only the time from a timestamp column. =SUBSTITUTE([Start Time (Timestamp)]@row, DATEONLY([Start Time (Timestamp)]@row), "") It works fine for any timestamp that occurs prior to 7:00PM, after that time, it pulls the date as well. I also…
-
Auto populate date column when column is checked off formula
Hello! I need help figuring out a formula for the following... 1 - Date Column Title: Handoff Date 2 - Dropdown Column Title: Onboarding Progress Essentially, when the status of the 'Onboarding Progress' reaches "handed off to qualification" and is checked off in the dropdown column...is there a formula that will…
-
Auto checkbox formula for a date
I'm looking to have a checkbox column be automatically checked off whenever the date column next to it is filled in...here are the two column names: SQV Scheduled - checkbox formula SQV Date - date column (next to it) This is the formula I have: =IF(ISDATE([SQV Date]@row, 1, 0)) It's not working :( help!
-
Parent row possibility?
I have an idea but I'm not sure it's possible, need some advice. I have a form I've created with an option to add 5 submissions. I need to be able to total these submissions based on who filled out the form. Right now I have a helper column that adds the submissions up that are on the row, but I wondered if I couldn't set…
-
Concatenate Integer + Words?
I work in events. I group my tasks by how many months out the task is from the event date (1 month out, 2 months out, etc.). I'm wondering how I can create the `1 month out from event` in field using a formula. I'm coming from the world of Airtable where I could calculate how many months a Due Date was from an Event Start…
-
Please help me correct this formula!
=IF(AND([% Complete]@row < 0, [Start date]@row < TODAY(), "Not started", IF(AND([% Complete]@row > 0, [Start date]@row > TODAY(), "In progress", IF(AND([% Complete]@row < 100, [End date]@row < TODAY(), "Overdue", "Complete")))))) Hi - I've created this formula but getting the "INCORRECT ARGUMENT SET" error message. I think…
-
Adding another layer to my report formulas i.e. another way to group the statements
I'm trying to filter a report with multiple levels of filtering, however, I can't seem to find a way to add the last level. I have 4 groups of AND statements bound together by an OR, but I need to add another AND that binds that whole previous statement together. I want Record type is equal to "Opportunity" to apply to all…
