-
Check box if date is equal to or between dates
I want to create a formula to do the following: If the "Created Date" is equal to OR between the "Week Start" and "Week End" dates, I want to check the "Submitted on Time" box. I tried =IF([Created Date]@row, >=[Week Start]@row, <=[Week End]@row, 1, 0) and am getting an INCORRECTARGUMENT error. I'm sure I'm missing…
-
Balls Changing Colors
Hello, Why is the signal status color column populating a color when I have nothing in the value column? How do I stop this? My current formula is =IF(Value@row >= 90, "Green", IF(Value@row <= 84, "Red", IF(Value@row < 90, "Yellow"))) Thanks!!
-
Problem with nested IF statements
I was successfully able to write a formula to fill in the value of the User 2 Action column with the value of User 1 Action if Prod User 2 is not blank: =IF(AND(NOT(ISBLANK([Prod User 2]@row)), NOT(ISBLANK([User 1 Action]@row))), [User 1 Action]@row), "") I would like to add one more level to this where the above works…
-
Rolling updates - can I automate data selection for dashboard?
I have a set of dashboards used to show the same data every reporting period. Reporting periods are 100 days long. They are identified as Start Month - End Month (x00 days). Is there a way I can automate data selection for my dashboards so that it picks the current reporting period ? Data feeding into the dashboard comes…
-
Visual Status Alert
Hello All! I hope this is an easy soulution. Can anyone assist me with creating at status alert based off of today's date and a start date? I want the Delay Status to automatically put the status listed and color the cell. If a Cleard to Start has a check mark, then it shows no delays and color coded green. At some point,…
-
Total number of inquiries is off by one
I am fairly new to Smartsheets and racking my brain trying to solve this problem and I am hoping the community can help! I have a log sheet that we use to keep track of inquiries received through one of our channels. I have the 'Inquiry type' column, that has the multiple dropdown option for all the different types, and…
-
COUNTIF is Not Working as a Sheet Summary Field
I am trying to create a count of how many rows in my sheet meet a certain criteria. I created a Sheet summary field and used the COUNTIF Formula. However, it keeps returning #NO MATCH when there clearly are rows that meet the criteria. SHEET SUMMARY FIELD FORMULA: =COUNTIF(Fund:Fund, 160) Here is a sample of the data in my…
-
Finding the oldest date on multiple sheets and also based on text in another cell
I have 2021, 2022, 2023, 2024, and 2025 sheets with different departments' requests for action (RFAs). I am looking for a formula to show me the oldest open RFA for each department. Some departments will be in 2021, but some will be in 2024. A sheet summary formula is not what I am looking for. I need a reference sheet…
-
Copying a one cell to another between sheets
I am trying to copy a specific cell from my main sheet to another cell on a different sheet. I have tried using the cell linking feature where I right click the cell I want the information to go and select "link from cell in another sheet" then select the cell I want on the main sheet and select create link. When I do this…
-
Removing semicolon and pull multiple values from reference sheet
Hi, I have two sheets: Sheet 2 (reference sheet, see photo 1) and Sheet 1 (formula sheet, see photo 2). I've created a formula that works when the item number column is a dropdown menu with multiple selections. However, I need a formula that achieves the same results when the item numbers are separated by semicolons ";" in…