-
SUMIF formula that calculates the criteria between a number range
Having a blank mental moment. I am trying to create a sum if formula to total all of the "medium" priorities using a range of numbers. High is fine as i just did a greater or equal to (>=) and likewise (<=) for the low. When I get to the medium priority, I can't work out how to do an "in between". Below is a screen shot of…
-
Formula to Change RYG Status Ball if One or Another Cell Values is Set
Hello, I'm trying to figure out the right formula to change the RYG status ball depending on the status set in two different cells. I've tried various IF and OR combinations referenced in community threads but am missing something. Here's my column info: Column 1: Engagement Column Status to trigger Red status ball: Left…
-
How to track late information
Hi, I'm looking to track information that has been received late on some sheets. See below example where date information required was 17th July and we received the info on the 26th July. I am using =IF([Date Information Received]@row > [Date information Required]@row, "Yellow") to turn a symbol yellow if date information…
-
Formula to update a cell
I want my column for progress (Not started - In progress - Complete) to update when someone adds the % complete. So is "0" then read "Not Started", If < the 0 but not 100% then "In Progress" and if 100% then "Complete". Does anyone know that formula?
-
Is it possible to capture or reflect unknown category(ies) in a dashboard chart widget?
In an effort to scale up a department Smartsheet Dashboard I developed using Summary Sheet Reports for my organization, I am faced with trying to include data from a category where the category information is unknown. Meaning the category data will be input by the different departments. Is there a way to collect this…
-
Parent Row % Complete Doesn't make any sense
See attached image The Parent Row shows 7% complete based on the 1 item being 100% and all other items being in the future. The target % complete shows 20% which makes no sense to me. There is a formula for Target % complete: =IFERROR(IF(Status@row <> "Completed", IF(NETDAYS([Today (hidden)]$1, [Planned End]@row) /…
-
Formula to return the logged in user
Hello, Is there any formula to post(return) the name of the logged in user? I am trying to record the user name of the person who checked a box. for example, If I want to post a date when a box was checked, I write: =IF(Closed1 = 1, TODAY(), "")can we have something like =IF(Closed1 = 1, Logged user, "") I know that there…
-
Merging data from multiple sheets
Hello I have over 100 smartsheets with the exact same columns and questions. These sheets have been sent out to leadership teams across the country. I need to combine all this data into ONE summary sheet. Is there a way to do that? I do not want to link EACH cell to hundreds of sheets. let me know if there is some magical…
-
Sheet Summary field, max date, ignore blank cells
Hi, I have a sheet with active jobs, some are scheduled and some are not. I want the Sheet Summary field to show the furthest date listed, but some of the rows do not have a date in the selected date column, and I want to be able to select the entire column to pull from so I don't have to expand the selection every time…
-
Conditional Formatting in same column with multi criteria
I am trying to think my way through this and can't quite manage it yet. I have a log that has stages but the criteria is based upon the substrate chosen. If Hot dip is selected, the temperature spec is 120-160. If Cold Rolled Steel is selected, the temp spec is 120-175. I need the conditional formatting in the same cell,…
