-
Summary Sheet Symbols and Projection Question
Hi, I am trying to do a few things. First, I would like to pull symbols into the Sheet Summary based on the following criteria: Most Recent Entry for Site A. Pull symbol from the "▲ ▼" column. Second, pull the... Most Recent entry for Site A. Pull symbol from the "Status of Goal" column to sheet summary. Lastly, I would…
-
Formula for % Complete - Checked Boxes + Total items listed
Hi, I'm trying to calculate the % Complete on a sheet. The data will be coming from the total number of boxes checked "Complete" and the total number of items on the list (Children). I just keep getting Invalid Operation and Incorrect Argument Set.
-
Simple question, How do I automate my RAG status column based on dates?
This is for contract management circumstances. Green=Contract is active no issues Yellow= Contract is due to expire in 90 days (I have a column with the contract expiration date in it) Red= Contract is expired (Again this would be based on the value in the contract expiration) I checked the Automation and there doesn't…
-
COUNTIFS from one date through today with other criteria
Hello! Needing help creating a formula. The formula has to count all the cells in the "clearance date" column that are blank with the criteria from the "application effective date" which is all dates happening 10.1.2021 through today (which means counting on a rolling basis) I have this formula below that isn't working:…
-
Formula for 2 criteria
Hi, I'm trying to come up with a formula to count all the students in grades K, 1, 2, 3, 4, 5 who are also in our life skills program. I have the formulas separate =COUNTIFS(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6) =COUNTIF([Life Skills]:[Life Skills], 1) I tried =COUNTIFS(Grade:Grade, ="K") + COUNTIF(Grade:Grade, <6)…
-
What's wrong with this formula?
=IF(Due date,<=Date closed, "yes", "[No]") the intent is to record yes or no in a helper column dependent. The former if the date closed is on or before the due date. The latter if after the due date. Thanks in advance
-
Issue with Date column with formula =today()
Hey Smartsheet community Has anyone encountered this issue where the Date field with the formula = today() is not updating on its own until and unless you open up that sheet? I have a sheet which powers my Dashboard and I need to open up this sheet so that the date column reflects todays date and hit save, else it will be…
-
IF with INDEX MATCH
Hello, I would like to check a box on one sheet, if a box is checked on a different sheet, matching certain criteria. This is what I have so far: =IF(INDEX({Current Estimates Range 1}, MATCH([Project Name]@row, {Current Estimates Range 2})) = 1, 1) If the Takeoff Information Column is checked on this sheet, then check the…
-
Creating horizontal view for existing sheet
Hi, I'm trying to get sheet A (vertical view) into sheet B view (horizontal view). Sheet A: Sheet B: the helper column date is in txt/number so it would match sheet A. Could anyone help? Thanks. :)
-
Formula for Finding ISBN Numbers
I wanted to share a Formula / Method for validating ISBN numbers since I didn't see any discussions or suggestions on how to go about, I thought I would make a post here for if anybody wanted it or had discussion ideas on it. I was recently tasked with creating a book request form where users would need to submit ISBN…