-
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")))
-
Not sure why this formula is not working
Hi all, I have this issue where I'm trying to have Smartsheet automatically respond no to a column if the same person was requested before and said no already. IF they said no, the row would copy itself to the bottom and replace the one that said no's info with the next one requested. Thats where I would like smartsheets…
-
Calculating Due Date Based on 2 different criterias
Hello! I would like calculate the due date based on the date based on "Date Received" and "Type of Request". I have been doing this manually and it would be great to have some sort of automation by using a formula then that would be fantastic and save so much time. The challenge is creating the formula and I have not been…