-
Symbols for Status
Why are my words not translating through to symbols? The formula seems to work since its returning the text, but ist converting it to symbol form =IF(Status@row = "Assigned / Not Started", "Empty", IF(Status@row = "In-Progress, On-Schedule", "Green", IF(Status@row = "Delayed", "Yellow", IF(Status@row = "Complete", "Blue",…
-
Formula help to match contains
Hello! I have 2 sheets: Sheet 1 contains [UserId] column Sheet 2 contains [Assosiated User] and [Machine Name] columns I need to Use [UserId] to look up if [Associated User] contains text to match [UserId] and return the value of [Machine Name] at row Just cannot seem to figure it out. Any help is appreciated!
-
COUNITFS w/Ranges from Multiple Sheets?
Hi all, I'm trying to create a COUNTIFS formula that will look for the same criteria within multiple sheets (5+ sheets at a time). I have my criteria in one sheet, and want to look across other sheets for instances of that specific criteria, then tally up the instances in the original sheet w/the criteria. I'm setting a…
-
Finding Average of Cells in Another Sheet
Hello, I am trying to find the average of "% completes" percentages from one sheet to another that meet a certain criteria. Here is the formula I have attempted however, I am receiving an "Invalid Operation". Is there a way to accomplish this without selecting each cell individually? =IF({Team} = "Marketing", AVG({%…
-
IF Formula - 2 Conditions and 1 Flag
I have a column that houses a flag to notify if the billed hours breach the budget. But I am trying to use two conditions where it doesn't run if Contract Type contains T&M. My first attempt right now: =IF([Billable Consultant/Developer Hours]@row > [Consultant/Developer SOW Hours]@row, (IF([Contract Type]@row,…
-
workflow to be triggered when cell is changed to specific value
Hi all, I would like to create a notification workflow to be triggered when cell is changed to specific value. Is this possible? Thanks in advance!!
-
Count previous month items
Hi i am creating a metrics for a Dashboard and i just need a count of new items that were created in the previous month. I am using as base the "created date" column. For your reference i already have one that is counting the items created during the current month and it is working. What i don't know if where to include an…
-
How to count number of tasks and due dates of another sheet
Hi, I'm trying to make Metrics sheet which I would like to calculate the number of tasks of each person by name and also their past due tasks I did some formulas but they seem to be #INVALID Below are the formulas I did for tasks : =COUNTIFS({Name of other sheet Range 1}, FIND("Name", @cell) > 0) Formula I did for past due…
-
*urgent request* - Days until Formula
Hello SmartSheet World, I am wondering if there is a good formula that can provide me the number of days until a date is reached? In the snip below, there will be a date added to the "CO Date ..." column and next to that column I want to create a formula that tells me how many days there are until that date arrives. Is…
-
Networkdays and If formula help
Hello! I could really use some help. I've reviewed previous Q&As and can't get my formula to work. I want to calculate net workdays based on a specific status selection and have it stop counting days once the status has changed. Status is in dropdown selection box. I've automated the start date to populate when the…