-
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…
-
Getting formula to deliver health symbols
Hi there! I'm trying to generate a health symbol for a column in my sheet and have created the below. I've indicated that the row is a "symbol row" and have successfully gotten my formula to deliver the the words "Gray" "Green" "Yellow" "Red" but it's not populating the symbol. Any help here? Is it a formatting thing or an…
-
Dynamic Formula
Hi! I'm using smartsheets to manage my business's projects and I have an automation that triggers when my PO checkbox is ticked, so that it copies the project over to a separate client sheet. Necessary so that I can keep all of my projects for Client A, B, C etc separate, for some specific calculations I need. (Mainly…
-
Countifs with two contains
Why does my formula show #UNPARSEABLE? =COUNTIFS({[Name] Initiative - RAID Log Status}, CONTAINS($[Column7]$120, @cell), {[Name] Initiative - RAID Log Action Owner}, CONTAINS(Input@row, @CELL)) $[Column7]$120 includes the word "open" Input@row contains a name Reference {[Name] Initiative - RAID Log Status} is a column with…