-
Row numbers
Hi, I have seen multiple threads around this but still I'm surprised there is no dynamic solution for this, I have tried auto populating ROWID by AutoNumber column and as you can see in screenshot whenever I try to add a new row in between it calculates the row number from the bottom (WOW), this is very bad and this is…
-
Last 7 Days
I need a formula that counts the number of requests that have been submitted within the last seven days if assigned to "John Doe". Smartsheet's AI generated this formula, however it comes back to me as #UNPARSEABLE. =COUNTIFS({Filing Submitted Date}:{Filing Submitted Date}, {Filing Submitted Date}@cell>=TODAY(-7), {LRT…
-
Dynamic Unique values for Dashboard
Goal: I want to dynamically extract "Top 5 Customers by Spend". Context: -Sales Dept. uses a sheet to register future projects. Important columns: "Customer Name" and "Spend". Considerations: - "Customer Name" could appear more than 1. -In rare occasions, two "Customer" can have the same spend, so both should be considered…
-
Formula Assistance 🙏
I have the following data set: Wellness Annual Total Wellness Expense Wellness Remaining Education Annual Total Education Expense Education Remaining $1,000 $500 $500 $5,000 $4,500 $500 I am trying to write a formula for the wellness remaining column, but I have a rule I must follow that is giving me a headache for the…
-
Conditional Formatting for Dates
I have two columns, one with a projected date and one with an actual date. I want the actual date to turn red whenever it is later than the projected date. How would I make this happen?
-
Pull most recent entry based on date comparing two sheets
Hello, I am having an issue writing out this fromula and needed some assistance. I need to write a formula that checks for an ID number titled MLL ID [ie. MLL00132] that is an auto number on the sheet I'm writing the formula on. I need it to look at two sheets, an open work and a complete work. Both sheets have a created…
-
Creating Conditions that affect other rows
Hello, I am super new to smart sheets, but have done very well with 99% of what I have needed to accomplish, however… When trying to create a condition labeled "Yes | No," and if Yes is selected in that row, then I want it to highlight another row also in the primary column to red to highlight it being the next step to…
-
I'm trying to generate a formula for obtaining time difference in HH:MM (24hr time format)
Hello, I'm trying to find a formula to fin the time it take for an individual to submit a form from "Start time" to "Ticket closed time" is a HH:MM format (24hr time) If its easier id also be happy for it to simply be in minutes. I've attached a screenshot of my sheet. Thank you.
-
Trying to index match across multiple sheets, need assistance
I am trying to index match across multiple sheets. Each sheet is specific to it's own project and I want to index certain values on a master tracker for all projects. Each sheet is broken down by site name and each site has it's own progression. The column name for the site is named Site ID and the column name for the…
-
Convert VLOOKUP to INDEX/COLLECT?
Hi, I am trying to calculate the fees for a project based a list of fees from another sheet. My current formula works when only one product is selected but does not work for multiple products. Would converting this to INDEX/COLLECT work? And if so, how would I do it? Current formula looks up the value in Project Type/Scope…
