Formulas
Discussion List
- 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…
- Hello everyone, My team has a sheet with Submitter, Country, Recommendation columns. Each Recommendation is related to a Country. According to the Country, the Submitter field would have to be automat…
- Hello! I have a drop down column with 14 options and the ability to allow multiple values per cell. It is a sheet to show different company internal initiatives, when they are happening, and which tea…
- Hi everyone, i have an issue. I have formula which is influenced by several columns and conditions, here's the formula. =IF(OR(CONTAINS("PW"; Task@row); CONTAINS("PC"; Task@row); CONTAINS("PF"; Task@r…
- Is there a formula that would check if the number ID in one sheet is also found in a separate sheet?
- This is a complicated one so bear with me. We have an form users fill out and one of the questions on the form is multiple choice where they can select more than one answer. There are 3 correct answer…