-
Auto-Refreshing Sheets/Grids - to auto update formula cells.
I saw a post in the community at https://community.smartsheet.com/discussion/auto-refreshing-sheetsgrids which had a similar question. But no answer was provided and the last update (from another member) was in Dec. 2018. Again, no response or answer was provided. I have a sheet, with formulas, to calculate today's date,…
-
How to select a last added value from a column
Would love to get feedback on how to get a "Last added value" of a particular item. I have a list of items which keeps adding in the sheet as new rows. I need a formula that looks at a column to pull the latest value/entry made. What I want is a formula that updates automatically as I populate new rows. Below is a…
-
How to take "canceled" out of the equation
Hello! I am trying to make it so an exclamation point appears if something is past due and not complete. Here is my current formula: =IF(AND(NOT(Status7 = "Complete"), TODAY() > [End Date]7), "High") This is working great but it will have an exclamation point appear if something is past due and canceled. I would like for…
-
Update a Status Formula
Hi, I currently have the following formula for a status column: =IF([Expiry Date]78 < TODAY(), "Expired", IF([Expiry Date]78 < TODAY() + 60, "Expiring Soon", "Current")) However, I have now added a column that is a checkbox titled "Re-Training Not Required" and another checkbox column titled "Inactive" (If the checkbox is…
-
Formula return blank result
I've attempted multiple times to create a function that result in Blue, Yellow, Green, Red health and it has been unsuccessful. Here are the results that I am aiming at: On Track > "Complete" "In Progress" = Green Ahead > "Complete" = Green Ahead > "In Progress" = Blue At Risk > "Not Started" "In Progress" = Red Behind >…
-
Cross-Sheet Reference Limit
Concerning the current limit of 25,000 total cross-sheet references per sheet - is there an easy way to determine how many are currently being used on any given sheet? Thanks!
-
Updating an aggregation sheet/dashboard with weekly data
Hi all, I'm struggling to think of a way to aggregate data that changes weekly. I will try and describe as best as I can! We have a sheet that financial advisers fill in weekly (separate sheet for each adviser) to show various information as attached in the screenshot. The adviser updates this weekly every Friday, and adds…
-
HOW TO REMOVE #DIVIDE BY ZERO AND MAKE CELL BLANK
I am trying to average a customer feedback section of my sheet. But if the cells where the data to be averaged will come from, the result section shows #Divide by Zero. I use the formula =AVG([column1:column2]). What's the formula I need to use for this? I saw in the other community discussion that I can use IFERROR but I…
-
Forumla Help, Nested IFs
Hi, Looking to see if someone can help me with this formula. I would like it to follow the following logic: * If Task is checked as complete= "Green" * If Task is past complete by date and not checked as complete= "Red" * If Task is 3 days until complete by date and not checked as complete ="Yellow" Here is the what I have…
-
Problems figuring out nested-IF formula
I'm having difficulty figuring out what is wrong with my formula in attempting to use a nested-if formula to automate the RYG light in the "Status" column, depending on the "% Complete" column. Here is my formula: =IF([% Complete]3 < 0.7, "Red", IF(AND([% Complete]3 => 0.7, "Yellow, [% Complete]3 < 1.0, "Yellow", IF([%…
