-
Open hyperlink based on selection in a form
I want to send a user to two different links depending on their selection in a form, is that possible? Example: If one person has insurance they click this box and sends them to a link after they fill the form out. and vice versa if they don't have insurance. I know there's a feature to send them to a url after they fill…
-
Formula to reference another sheet
Hello, I need to make a formula for the following and appear to be missing something or doing it wrong. If the Date Field is filled in, then i want the Project Manager field to fill out based on a cell in another sheet. I have the first part of =IF(Date@row >0
-
How can I automate a subtraction
Hey, How can I subtract a number from the total each time a row is added. I have an Inventory sheet that linked to another sheet. for example, in the picture below; how do I subtract a Number of Machine each time a row is added? Thanks in advance.
-
Referencing Multi-Select Dropdown in a Formula to Get Elements On One Line
Hey everyone, By default, if you a cell in a multi-select dropdown column with more than one option selected and then copy/paste that cell or reference it in a formula, each element is pasted on a separate line, like this: Is it possible to get all the elements on one line with commas, like this? Thanks!
-
Average Children they are not 0
Hello - We are building a tracker that rolls up averages for a series of values across child rows. We have a top level value, with 12 children for each month, and each month as children rows of workers. So for example Manager Indent(January) Indent(Indent(Worker 1) We are trying to roll up for the manager, by month, as…
-
How to create a conditional formula with date specifications?
How do I create a formula that counts the number of rows containing [STATUS] “Green” and have [DATE] = Today and [DATE] = Last Seven Days from Today. I do not want to capture rows that are older than seven days from today.
-
Trying to add a IF date around a countifs statement...
My goal is to only count " =COUNTIFS({ZenQ Testing Required}, FIND([Primary Column]3, @cell) > 0) " if the date is within 2020 year for the created date of the jira ticket. Can someone help?
-
Help IF/AND formula with RYG conditional formatting
How do you create RYG symbol formula that requires multiple conditions of multiple reference cells? Here are the conditions I'm trying to write a RYG formula for....using reference cells [LEADER NAME] and [RISK FLAG]: If [LEADER NAME] = BLANK, then keep cell empty If [LEADER NAME] = NOT BLANK, AND [RISK FLAG] = CHECKED,…
-
Autopopulate text based on drop down option
Hello! I'm trying to figure out a formula to autopopulate text in a cell based on a drop down option in a previous cell. Basically one column would contain the drop down (Campus) and based on which campus is selected, a different cell (account) would autopopulate. Ideally it would look like this: Campus (drop down) Account…
-
Marking Oldest 5 Projects
Hello! I have been working with some data and I want to eventually be able to pull a report of my "past due" projects and show the oldest 5 projects. To do this, I have created a helper column in my source sheet that using the formula: =IF(Date@row < SMALL(Date:Date, 6), 1, 0) in order to flag the 5 oldest dates in my due…
