-
Formula to generate date 1 year from today?
I am trying to figure out a formula that will generate a date that is 1 year from today. For example, if we have a contract that requires 12 months of notice to cancel, and I have a column to track the Earliest Possible Termination Date, I want that column to tell me the date that is 1 year out, or 365 days after today.
-
What might be causing "cell link" to set a cell to blank?
I have a health status cell that's calculated based on multiple conditions to become a red/yellow/green ball, but at seemingly random times, cell link changes it to blank. Then a few minutes later, it says my user changed the status back to green. This cell is based on a column formula, so the user could not have changed…
-
MAX(COLLECT) Formula Returning Invalid Operations Error when Number Begins with 0
Hello, I have a column formula that has been working in a sheet to designate the latest entry for an employee based on their employee ID. =IF(MAX(COLLECT([Ship Date]:[Ship Date], [Employee ID]:[Employee ID], [Employee ID]@row)) = [Ship Date]@row, 1, 0) Today, some employee IDs that begin with 0 were entered. Those rows now…
-
Symbols on all Columns
Hi everyone, How can I apply symbols to all columns without have to individually right click on column to pick a symbol? Thank you!
-
Need Help with IF and IFERROR
Hello, I have the IF part of the statement working just fine =IF([NEXT Month Quarterly from Today]@row = [NEXT Month Quarterly Due Number]@row, "Yes", "No") - basically it is evaluating if the next month from today is the same month as when the next maintenance is due. In rows where there is not yet data I am getting…
-
Formula help - difference between two form submissions based on a couple of
Hello, I need assistance with creating a formula to calculate the time difference between two submitted forms. One form is submitted when a person checks in, and a second form is submitted when they check out. I'm seeking a formula that considers the date stamps in relation to the Site Address and Check-in Action columns.…
-
Approval flow status - need help
Hello, I am in the process of creating a sheet (two separate forms depending on requesting line of business). My team handles one operation while my peer handles another. I have the automation when forms for specific lines of business it will send our respective teams an update will be sent via email. I also have a hidden…
-
Fill in Pricing based on condition of a cell
Hi, I am trying to have a cell fill in pricing based on the size of a sign. so if it is a 22x28, it should be $100. The column with sign type has different drop down options... 22x28, 44x18, 110x100... and depending on what drop down is chosen there the cost should automatically be filled in. Also not sure if it is…
-
Trying to create helper column that pulls cell based on current month
I have tried a few things now, looked around through numerous articles - but I cannot seem to get this to work. I need some metrics to auto-update each month on a dashboard, and so what I have at least determined so far is that if I can have that metric point to the same field (to avoid manual updates every month), but…
-
IFERROR, NETWORKDAYS, and MATCH all in one?
Is it possible to have a formula that includes IFERROR, NETWORKDAYS, and MATCH? I'm working with two different sheets, both of which have a start date and an end date column, along with a project ID column. In a third sheet, I need to reference the start and end dates of both sheets using the NETWORKDAYS formula to…