-
Automated Allocation - based on selected attributes
Hello Smartheads! I have a pretty interesting use-case. Columns look like in the screeen below: E Entry Number - values can duplicate Desired outcome: Trigger: Auditor selects her/his user ID in column C Audotor in a row. Outcome: After changing one row, the same user ID will be populated in Auditor column, if ENTRY NUMBER…
-
Formulas in Automations
Is it possible to create an automation that will populate a cell with a formula instead of text or a drop down value? I am trying to get a column to populate with the name of a user who checked a box. For the action block of the automation, I selected Change Cell Value in Column to =([Modified By])@row The automation…
-
HAS function with multiple valid choices
I have created the following formula to calculate aging for a row that has not been completed: =IF(AND(HAS([Issue Status]@row, "Pending FWCI Triage", "Pending DC Fix", "Pending Fix", "JIRA Ticket Opened")), [Date Issue Closed]@row = "", NETWORKDAYS(Date@row, TODAY())) The test criteria I used is the following: Positive:…
-
Conditional Formatting for a Modified By Column
I am trying to create an automation or formula to populate a cell. Here's the gist of what I am trying to accomplish: Only when a completed box in a column is checked → I want to populate another cell in that row with the Current User who checked the box. I would like this to populate automatically through the use of a…
-
INDEX/MATCH/COLLECT How to get most recent entry by person and by most recent date
Good afternoon, I have been spinning my wheels trying to get my formula to work and scouring the community. Hope someone here can help :) I have employees that need to checkout items and they record this by form. My want is to pull the most recent date based on name and whatever item they checked out. Sheet A w/ the form…
-
Counting Status Changes
Hello, I'm working on a document tracker that has statuses changing back and forth several times. I'm wondering if anyone has any ideas how I could count each time the status changes. For example, they default to Not Started. Once changes from Not Started to Awaiting Requirements, that's 1. From Awaiting Requirements to…
-
Another Formula not working
Hi again, Im having an issue where im doing an index match on 2 columns across 2 sheets. I have double check the email that the index match is matching to and from. I am not sure why the index match is only picking up 2 rows and not values from all of the rows. I've tried doing manually putting in the email in the blank…
-
IFERROR formula returning nothing but one cell is working
I am working on a formula that would return the "PTO Available" Column number based off the "Years with CO" and the "Days Accrued" per year. Its only returning one cell?? Thanks in advance for your assistance! Jennifer
-
Formula to use in the summary field for the number of rows within a specific column
For example: If the column is about colors, I want a formula to see how many people chose red or how many people chose green in the survey. And I want this formula to put into the summary field so that I can upload into my summary report and into a chart in dashboard.
-
Nested IF Fomula help
Hi! Can anyone tell me what is wrong with my formula below? I am having trouble identifying =IF(ISBLANK([Contractor Name]@row), "No", IF(OR([Contractor Name]@row = "NA"), "No", IF([Contractor Name]@row = "RLM"), "No", IF([Contractor Name]@row = "Danny"), "No", IF(ISBLANK(Phone@row), "No", "Yes")))