-
IF formula to compare due dates to show completion schedule
Hello all! I have a formula that is stumping me - I am looking to compare a target due date versus the actual completion date. I have a formula that is partially working, but am running into issues when I use the term "ongoing" on the target due date column (see Project 4 in the below example). This is what I'm trying to…
-
Formulaic Help / Cross-Sheet References
Bit of a complex one: Let's say I have a sheet named "Additions To Scanning Workflow" (with a select number of users) that includes 13 columns of data, one column ("Ready for Digitization Dept.") that's a checkbox field. I want the select number of users to be able to fill out this sheet and when the "Ready for…
-
How do I add age range
I am trying to take a list of all employees that includes their info like department, name, and age and then create a age range (like 16-24, 25-34, etc...) so I can then count how many employees fall under each age range. I have tried two ways and neither work. FIRST ATTEMPT: -The first and i think easiest is to have a…
-
Restricting a formula to a certain timeframe.
Hi There, I have a Smartsheet and Form that we use to calculate how long a person was checked into a function to account for down time. Since Smartsheet is not very good with calculating time it took some creativity go get a formula to match up 2 different rows with the same information to calculate the amount of time…
-
Help with IF formula
Hi there! Does anyone know if there is possible to extract a portion of a text in a cell? (to be specific, I only need to pull the first 5 characters from the left) I currently have a formula to "map" a list of values (using IF function), but now we have added this long list of alphanumeric codes into the "ComponentID"…
-
Copy row automation from a formula based column
I have 3 intake sheets for a multi tier blueprint, I am using data shuttle to bring in all of my clients, program and project to one master sheet and from that master sheet, I have 3 formula based check box columns to track if the client, program or project exists or doesn't exist. If it doesn't exist I want to copy the…
-
Three criteria SUMIFS
Good afternoon! I am trying my hand at getting some detailed information about hours put in by volunteer by location. What I am trying to pull is from the screen shot in the two attachments. here am I messing up on this formula? =SUMIFS({Time (in yellow)}, {Location (in green)}, {Date (in blue)}, AND Location2 (orange)…
-
Sheet formulas are not auto-updating until the sheet is opened
Is this still a known issue with the TODAY() function OR is there a way to get around it? https://community.smartsheet.com/discussion/59131/sheet-formulas-not-auto-updating?_gl=1*hx7amf*_ga*NDg5OTI2NTg5LjE3MDYwMzk4MDY.*_ga_ZYH7XNXMZK*MTcwNjgwOTkzNi41LjEuMTcwNjgxMDAwMy41OS4wLjA.
-
How do I convert dates into a time period (month) for reporting?
I am creating a savings dashboard and my primary sheet records the date the PO is issued. In my dashboard I want to display my savings by month or fiscal period. Is there a formula that will convert my rows with PO issued dates between date ranges into a fiscal period/month. Example: I want to convert row cells with any PO…
-
Help with Collecting Data for Metrics w/Multiple Criteria
I need help to collect a sum of financial information based on a range of dates in the future (or past) SmartSheet Name: Renewals-Active Column Names: 'MRC' is a text/number column and contains the financial information 'Estimated Contract Exp. Date' is the date column that contains dates (past, today and future) 'Primary…
