-
How do I alert someone if the "Completion Date" is blank after 7 days from the "Submission Date"?
I have a column for date submitted and there is a column for Completion Date. I want it to alert someone if there is no completion date seven days after the submission date. I think it is conditional formatting, but I cant figure out how to write it.
-
Convert to Column Formula - Syntax isn't quite right
Looking for assistance on how to apply this formula to the entire column. I believe it used to be but then at a certain point the new rows did not include it. This is the formula being used to calculate "Days Since Last Action", =TODAY() - [LAST ACTION]5993. The row number obviously changes with each row but I believe that…
-
How to assign contact with VLOOKUP?
Hello! I've been trying to get a contact assignment to work within my sheet and I'm not having any luck. I'm trying to have a contact automatically populate based on the site selected (in the same sheet and same row) so I can run an automation to notify said contact upon submission of a form. I initially thought this would…
-
Can a Sheet Summary field be included in a workflow automation?
In the SUBJECT LINE of a workflow automation UPDATE REQUEST email, I'd like to include a sheet summary field by using {{sheet summary field}}. Is this possible?
-
SUMIFS() formula showing unexpected results.
Hi I just tested and found out that if I am keeping the Status field blank, then the SUMIFS() function is not processing that row. I have pasted below -- the Summary cell formula, and the results coming in both the scenarios: Sheet summary formula =SUMIFS(Amount:Amount, [Due date]:[Due date], <=(TODAY() + 7),…
-
If/Then help
Hi All, I need help with an if/then formula. I am looking to put: if status = definite, then it will populate revenue from the total estimated revenue cell if status = actualized, then it will populate revenue from the actualized revenue cell if status = prospect, then it will populate revenue from the total estimated…
-
Using multiple conditions from multiple columns for CountIF
Hi, I'm trying to use conditional logic to count how many rows meet the following conditions. But I seem to missing something... =COUNTIF(([Approval Status]:[Approval Status], OR(@cell = "Approved", @cell = "Exception Approved")), +([Promo]:[Promo], OR(@cell = "Value 1", @cell ="Value 2", @cell = "Value 3"))) I've also…
-
Leave blank if row level < 2
I have a column formula with several nested IF statements. I want to add a condition at the start which says "If row is level 0 or 1, leave this blank; otherwise, run the rest of the formula." So I think I need something like this: =IF(LEVEL(Code@row < 2, "", [insert the rest of the formula here, starting with IF])) But it…
-
VLOOKUP
I am trying to use VLOOKUP to determine the column to pull a value from. My columns are basically months (1 through 12) and I need to use the 'current month' to determine the number 1-12 to get the value "@row". I am unsure if VLOOKUP can provide the functionality I am looking for so please let me know if I am asking for…
-
JOIN / SUM / DISTINCT / COLLECT
Hello, We have a sheet for tracking projections for project managers on multiple projects. I'm trying to develop a formula to return a list of project managers who have less than a certain amount of hours per month. I can do a formula to calculate how many hours that PM on that row has for that period, but I can't figure…