Formulas
Discussion List
- I have this formula in one of my sheets. It was a default formula and it mirrors the rest of the formulas on the page that all work, but it's coming up with #INVALID OPERATION. =SUM(COUNTIF(Priority:P…
- Hello, I am writing out a =If(or)) function right now and it will be way to long if i do it step by step and i am wondering if there is a better way to do this. So my formula is =if(or(Location@row="P…
- I am trying to create a cross-sheet formula that pulls the data from another sheet if it meets 3 criteria. In the source sheet, I need the following criteria met: 1. "Month/Year" column to be the same…
- Hi All, Hope you're all well. I wanted to filter the meeting minutes based on the selected date. I created hidden columns that contain the meeting number, author and actual attendees for that date. I …
- I want to calculate the working days from the start date. However, we have Sat as a working day which I have configured in the Gantt setting. (So we have 6 working days). When I use the formula WORKDA…
- Hello, looking for help with this formula. Need to calculate a future date based on the [End Date] Conditions: (1) Only display a future date if [Ord Amt] is true; (2) Future date to be one month earl…
- I have created a purchase order sheet and form which auto generates a number each time. How do I reference this number to pull it through into the form completion confirmation message and/or email?
- I have a dropdown, single-select column that describes the type of action item listed on that row. For example: If someone selects the Star symbol on that row, the column formula calculates that the a…
- Hello! I'm working on creating an environment within Dynamic View for employees to enter their annual bonus deductions. Is there a way to prevent employees from entering information into two columns i…
- I'm having trouble figuring out how to get multiple "IF" statements to run simultaneously. I need it to check the presence of text in multiple columns, but the Value if True, shouldn't stop the formul…