Formulas and Functions
Stumped by a formula? Ask for help or find examples to see how others use a formula to solve a similar problem.
Discussion List
-
How to have symbol ticked if the variance of baseline is more than -5 days behind. can this be done?In Formulas and Functions
-
Can I count data that is saved in a report?In Formulas and FunctionsI have a report that collects data from many sheets and gives me an output and a date. I need to count how many are in that report for a given date. Is there any way to count instances of something occurring in a report rather than a sheet…
-
A way to place the Row ID (for APIs) into a cell value with formula?In Formulas and FunctionsFor clarification, the ID I am after here is the Row ID you can view in the properties of a row. I'd like to be able to do something like have someone export a sheet and send it to me for processing, and have a pointer directly back to whi…
-
Why doesn't my Automation with a email work?In Formulas and FunctionsHello! I have set up an automation, where when a specific cell is changed to 85% and above, where a specific name is, it should notify the person and administrator. And my problem is that it doesn't notify the people. Note: there are about…
-
Auto checkbox problemIn Formulas and FunctionsHi, I am using these two formulas to auto check a box. =IF([Column Title1]@row = "Word", 1) =IF(ISDATE([Column Title2]@row),1) Both work individually, but i am having trouble nesting them and making them work together. I need th…
-
Date FormulaIn Formulas and FunctionsI have two quick questions; I need a formular to express the following: End date of column A = Start date for column B ( I tried setting the columns equal to each other but get an error) Second formula Column C = Column B +10 ( I tried…
-
Update date column when another column drop-down is selectedIn Formulas and FunctionsLooking for the formula to change a column to a date when another column drop-down is selected. The date would reflect the actual date the column drop-down list was selected Example If EPMO Stakeholder Decision (Approved, Declined, Deferr…
-
Timing Issue for Moving Row from Staging Sheet to Main SheetIn Formulas and FunctionsI'm building a workflow for our HR and Recruiting department to use to track job posting requisitions. If they check a box on the master sheet to repost the job again I am copying the row to a staging sheet, making a few cell updates to ch…
-
SUMIFS formula that includes a checkbox conditionIn Formulas and FunctionsHi everyone, I'd like to sum all cells in a column that are (A) in a parent row (B) have a certain name in the Producer column. I've inserted a checkbox column (called "Parent") with a formula to check the box if the row is a par…
-
Return a value, if a cell contains text from a range of optionsIn Formulas and FunctionsHi there! I'm not sure if there's an easy way to do this, so I'll try to break this out into parts: 1) I have a table with two columns - one with various text options (for easy, let's call these "flavours"), the other with the &q…
