-
How to I make this column stop counting one status is marked complete
=[Today date DO NOT TOUCH]@row - [Date Submitted]@row the formula i am using for days to resolution column. I would need this column to stop counting once status is marked complete by dropdown. Would need to be a formula I can make into a column formula
-
Compare Qty's in different sheets
I have 2 sheets. One is Contract Requirements and one is Hardware Deliverables. I want to compare the Quantities on the Contract Requirements to the Quantities on the Hardware Deliverables. For Example.. Contract Requirements list Qty 6 on one line Hardware Deliverables lists, 1, 3, 2 on 3 lines How do I sum the quantities…
-
Symbols in Sheet Summary Pane
Hello All, Thank you in advance for your help. I have a Red, Yellow, and Green symbols column in my grid view. In the sheet summary pane I want to have a summary column that provides the minimum value of the symbols column. When I use this formula in the sheet summary, =MIN([Project Health]:[Project Health]) I just get the…
-
If 2024 change to 2025 formula
Hello! I need help with updating formulas in a duplicated Smartsheet where the year is currently set to 2024, and I want to change it to 2025. Instead of manually going in and editing each formula, is there a quicker and more efficient way to do this? Additionally, I want to add an "IF" condition to ensure that if a cell…
-
formulas
Hallo i need a forumle which count the QTY hits of timing between 08:30 en 17:30. So in colomn F i need to have YES when the timing is between 08:30 en 17:30 Thanks
-
How can I display the current month number as a 2-digit number so it matches my year-month?
My ultimate goal is to create an automation that will look at the total audits completed for the current month and if the number <10, a notification will be sent. In order to do that, I need the 'current month' and 'current year' formats to match the 'Month' and 'Year' formats. I have tried =TEXT(TODAY(), "MM") but get an…
-
COUNTIFS Formula Returning 0
I am working a new summary sheet for metrics that will be displayed on a Dashboard. I am having issues with my COUNTIFS formula returning a 0. Current formula: =COUNTIFS({Projects_MASTER Range 1}, CONTAINS("Exterior Refresh", @cell), {Projects_MASTER Range 2}, NOT(ISBLANK(@cell )), {Projects_MASTER Range 3}, "1",…
-
Moving Comments Between Sheets
I am looking to find a method to copy select columns in a row along with the row comments from one sheet to another. Methods that I have tried and will not work in this scenario: Copying the entire row from Sheet A to Sheet B (This brings over all columns and I am only looking to copy over select columns) Using helper…
-
Options for appending data
I have a file, actually multiple files, one for each account. Each month they will get new data that I will need to append (add to the bottom) in 5 of the 23 columns. Is that possible in any way, or will I be forced to do copy/paste/ We are looking into Data Shuttle, but the only license is that of someone that already has…
-
Creating a conditional formula to summarize row data meeting certain requirements
New to SmartSheet and trying to learn the syntax for a formula I want to enter. I have a sheet with multiple columns to collect data on the health of an organization. I created a column for Risk Level and want to add up how many of these risk factors exist. For example, if ReserveFund is “No”, then add one to the risk…