-
Find Entry
I have different entries for same id . How to check what is the latest entry for that id For exampe:
-
What is the best practice way to chart number of new Rows by month, rolling 6 months?
What is the best practice way to chart number of new Rows by month (using Intake Date Creation), rolling 6 months? Intake Date Creation format is this: "09/22/21 6:20 AM"
-
Achieving Optimal Index-Match Performance
I'm wondering if anyone has any insight as to whether or not Index-match works any faster when the fields being used in the look-up contain numbers only, instead of text or text/number mix? In my own anecdotal experience, sheets that use index-match on numbers-only columns do seem to open/update/save faster. But I have no…
-
Dashboard bar charts showing blanks or ceros
Hi, hope you can help me. I am building a dashboard with some charts to show counts. I created another sheet where i am creating my formulas and tables that are the ones to create my chart in the Dashboard. As you can see my formulas are working fine and are showing counting just if the number is equal or higher than 0 if…
-
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!
-
IF, AND with NETWORKDAYS formula not working
I am trying to build an IF / AND formula with a networkdays calculation when true and "N/A" when false. I've tried many versions for over an hour and it is still unparseable. Any help would be greatly appreciated! =IF(AND(Status@row = "Ready for Review",[Assigned To]@row = ""), NETWORKDAYS([Date Submitted]@row, TODAY()),…
-
Looking for help with countif formula
I'm having some trouble with a countif formula, looking for some assistance. My goal here is to count the number of time the Created Date is last month and that the service type is "Trade Database - Add Part Number(s)" When I enter the formula below it works great! =IF(MONTH(TODAY()) = 1, COUNTIFS({Genie Archive Created…
-
IF and IF/AND formula - Please help! thanks
Hello, My current formula that I have is =IF(Status@row = "Complete", "Green", IF(Status@row = "On Target", "Green", IF(Status@row = "In Jeopardy", "Yellow", IF(Status@row = "On-Hold", "Yellow", IF(Status@row = "Past Due", "Red", IF(Status@row = "Archived", "Green", IF(Status@row = "Complete Past Due", "Green",…
-
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…
-
Reference the "Launch Date" in my dashboard
Hello, I've created a Dashboard for my project. I want to show the project Launch date, but I want it to reference the cell on my smartsheet, rather than manually enter the date. Do I need to create a formula for this to use on the dashboard?